Error:Data Procedure line (0) Error executing SQL query:

[segunfunwaoluwa]

Hi Everyone,
I have just built a REPORT ONLY cube and used Advanced Scripting to write the data load T1 for this cube.
I have successfully saved the TI but when i run it, it gives an error :
Error: Data procedure line (0): Error executing SQL query: "select pos.position_id as salary_position, etc etc.
It spells out the whole of my SQL Script that brings in data to my TI Process from my staging server.
The TI contains Parameters,Prolog procedure,Data procedure and Epilog procedures. My cube has 9 Dimensions which includes the measure dimension and has 8 numeric Variables &15 String Variables.
Please help in giving me pointers on how to resolve this issue.
Thanks
Segun

[Wim Gielis]

Please help in giving me pointers on how to resolve this issue.

The most obvious advice: did you test the exact same SQL query in the relational database itself?
Does it return the expected number of records?
Do you set the SQL query in the Prolog tab or in the Data Source tab of the process?
Do you use parameters inside the SQL query?
And so on.

[segunfunwaoluwa]

Hi Wims,
Thanks for your response.
Yes i did test the same SQL Query in the relational database but that was at the initial stage and it returned the expected number of records. I can still see my records in the preview.
I set the SQL Query in my Prolog Tab after but at the bottom after defineing my Parameters in the upper part of my Prolog Tab.
No i did not use any parameters in the SQL Query just some case statements.
Still hoping that help can be gotten to resolve this issue.
Thanks.

[jstrygner]

Error: Data procedure line (0): Error executing SQL query: "select pos.position_id as salary_position, etc etc.

And if you would paste the exact query from error log to either relational database (as Wim suggested) or in SQL Query box in TI, do you get records? Not at initial stage, but now while investigating the error.

And it would also be really helpful if you would just post your Prolog code, where you "construct" the query.

[Suharsh]

As many of the folks has said. Such error is encountered when there is an issue with the SQL (Otherwise the error would have been on some other line of Prolog).

If the parameters are not used in SQL, then I would suggest you to test your connection and see if the username and password are still functional.

Hopefully this should resolve your issue.