Can't figure out error

mkeevil · Post by **mkeevil** » Tue Jul 29, 2003 2:03 pm

I keep getting the following Permission Denied error, other people can run the process except for myself? Anyone got any idea's

ExtractSnapshotDate.CTransformerStage1: |ExtractSnapshotDate.CUvStage5.DSLink4: DSD.BCIOpenW call to SQLPrepare failed.
SELECT "SystemName","SnapshotDate" FROM "SnapshotDate"
SQLSTATE=42000, DBMS.CODE=36010
[Ardent][SQL Client][UNIVERSE]Permission Denied.
SQLSTATE=42000, DBMS.CODE=20142
[Ardent][SQL Client][UNIVERSE]Unable to open "SnapshotDate" file.|

tonystark622 · Post by **tonystark622** » Tue Jul 29, 2003 4:22 pm

Is this Unix or Windows? Are you in a different group than the other people that can run the process? What happens when you try to open this file manually?

Tony

ray.wurlod · Post by **ray.wurlod** » Tue Jul 29, 2003 6:18 pm

The message is telling you that you're generating SQL in a UV stage but that the UniVerse server is having problems opening a UV table called "SnapshotDate".
Check that you have the spelling and casing of this name correct. For example, is it actually "SnapShotDate"?
You might also check the operating system permissions on the Directory called SnapshotDate and its subfiles (DATA.30, OVER.30 and .Type30), and the SQL privileges (use the UniVerse command "LIST.SICA SnapshotDate" for this - the privileges are at the end of the report). If this is the problem get someone with owner or DBA privilege to execute "GRANT SELECT TO PUBLIC ON SnapshotDate;"

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518