Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Jagadeep Surakarp (JagadeepS) CPF Board Senior Consultant
CPF Board
SG
JagadeepS Member since 2014 10 posts
CPF Board
Posted: Oct 2, 2018
Last activity: Oct 4, 2018
Posted: 2 Oct 2018 1:02 EDT
Last activity: 4 Oct 2018 18:06 EDT
Closed

"dbo.pr_read_from_stream" calling instead of "pegaData.pr_read_from_stream" in query for Un exposed column fetch in Report

HI,

We observed in production ENV , when fetching unexposed column from the Report- In the query we can see

"dbo.pr_read_from_stream" calling instead of "pegaData.pr_read_from_stream" in query for Un exposed column fetch in Report.

Also we observed exception in the log as

There was a problem getting a list: code: 4121 SQLState: S0001 Message: Cannot find either column "dbo" or the user-defined function or aggregate "dbo.pr_read_from_stream", or the name is ambiguous.

This is happening only in prod environment.

Could some one help on this behaviour change ?

***Edited by Moderator Marissa to update platform capability tags****

To see attachments, please log in.
Low-Code App Development Reporting

Posted: 6 years ago
Posted: 4 Oct 2018 1:10 EDT
Hepsiba Komati (komah) Technical Solutions Engineer
Pegasystems Inc.
IN

Hi jagadeep,

Thanks for posting on PSC.

For  code: 4121 SQLState: S0001 message kindly look into below link which might be helpful.

https://forums.asp.net/t/1777116.aspx?Msg+4121+Cannot+find+either+column+dbo+or+the+user+defined+function+or+aggregate+or+the+name+is+ambiguous+

Regards,

Hepsi

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice