Cannot find the table for my Data Store in my Oracle SQL database

jurajb1 over 8 years ago

#SQLOracleDatabase
Hello guys,

I have a problem with my Oracle SQL Database. I am using the Data Store to save the data to the SQL table, fetch them and I can also show them on the dashboard. However I cannot find the specific table for the Data Store in my SQL Database.
For a CDT I used the same target namespace and for the Data Store I used the same source as for my other Data Stores I can see in my SQL database.

Do you know what could be the problem ?

Thanks

Discussion posts and replies are publicly visible

0 jurajb1 over 8 years ago

I can't run a select on the table, cause the DB says it doesn't exist
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jurajb1 over 8 years ago

could it be the problem with Oracle DB rights? that the table actually exists but I cannot see it because of rights
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PhilB
A Score Level 1
over 8 years ago

Yes, hence me asking if you're connecting with the same user as appian.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jurajb1 over 8 years ago

Ok, guys. Thanks for help. We solved it. The table was created correctly in the right schema but I couldn't see it cause the role was not assigned automatically when the new SQL table was created
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel