I'm currently working on updating a stored procedure based on workflow results, but I'm encountering an error in the Output tool despite the stored procedure updating successfully.
Error Message:
Error: Output Data (127): Error opening query: Microsoft OLE DB Provider for SQL Server: Invalid column name 'SubIndustryType'. [42S22 = 207] Microsoft OLE DB Provider for SQL Server: Invalid column name 'IndustryType'. [42S22 = 207] Microsoft OLE DB Provider for SQL Server: Invalid column name 'ClientType'. [42S22 = 207] ... (additional invalid column names: 'ExternalReferralType', 'OriginationDetail', 'OriginationRollUp', 'BDSignedOffName', 'FuzzyMatchName', 'CurrentAgressoName', 'ProjectCode', 'Client ID')
Context:
The stored procedure interacts with three tables: core.ACL, core.ACL_Code, and core.ACL_Projects.
What I've Done:
Included screenshots (attached) for additional clarity.
Verified that the stored procedure updates despite the error.
Any guidance or suggestions would be greatly appreciated!
Screenshots blacked out for confidentiality.
