Hello Everyone,
I am using a simple SELECT to fetch data from sql DB. The only SELECT it seems to fetch data is when it is getting data from sys tables. It does not work for fetching data from application tables created in the sql DB. Could this be a authorization issue? Listed below are the different SELECT statements used in PI and that works in SQL too.
1. SELECT Query : SELECT * from sys.tables
UPDATE : <TEST>
The above SELECT works and I can see all the xml messages in SXMB_MONI.
2. SELECT Query : SELECT * from sql_ztable
UPDATE : <TEST>
The above SELECT does not show any xml messages. There are records in the sql_ztable. When checking the CC monitoring I get the following message below.
Polling interval started. Length: 60.0 seconds
Processing finished successfully
Any suggestions?
Thanks,
Teresa