Error in FINSQL not in the FIN?????

kish2007

Dear All,

I installed SQL 2008 and NAV4.0. I am testing DB with our customer license. In FIN with our customer license the purchase order report( R- 405) is working correctly. But in FINSQL when i run the report iam getting error like " you do not have permission to read the Responsibility Center Table" . Iam using same license in FIN and FINSQL. iam running the report with SUPER user in FIN and FINSQL. i gave all permissions to the user.


Do you have any ideas.


Thanks & Regards,
kishore....

kriki

Which version of 4.0?

You should have at least 4.0SP3 with latest hotfixes for SQL.

kish2007

Hi Kriki,

It is NAV4.0 SP3 with HF6.


Regards,
kishore.

jannestig

If you are using your customer license most likely there is a table entry which contains the responsability centre.

Check the setup.

Are you using the cronus database ? they are two seperate DB's

If your customer license doesn't have the responsability centre on it you will get this error.

garak

which security model do you use?

kish2007

Thanks for your replies.

Now i got the solution. The Responsibility Table having data. when i run with our customer license it is getting error.

So i deleted the data.

Regards,
kishore.