IDM with SQL server Error: Cannot find columns for the table...

Hi all,I am Configuring IDM with SQL Server repository and ran into this error.'Cannot find columns for the table 'object'.....jdbc...[SQL Server]Invalid object name 'object'Can anybody please help me!!G

[250 byte] By [G_identitya] at [2007-11-26 20:49:30]

«« Running from the Command Line
»» allocate array elements one at a time?

# 1

Is this a new repository you are trying to connect to?If so then make sure there were no errors when you ran the create_waveset_tables.sqlserver script. Looks like the tables were not created properly.~Suvesh

suveshsharmaa at 2007-7-10 2:13:27 >

top of Java-index,Web & Directory Servers,Directory Servers...

# 2

I did it twice. Should I be looking at any grant permissions.

G_identitya at 2007-7-10 2:13:27 >

# 3

Yes. This is a new repository.G

G_identitya at 2007-7-10 2:13:27 >

# 4

Yes, permissions are very important. I ran into a similar problem because I didn't have the correct permissions. Make sure the user has the following permissions:

CREATE ANY TABLE

ALTER ANY TABLE

DROP ANY TABLE

CREATE ANY PROCEDURE

EXECUTE ANY PROCEDURE

DROP ANY PROCEDURE

Also, make sure there is enough space in the default tablespace of that user.

HTH

~Suvesh

suveshsharmaa at 2007-7-10 2:13:27 >

# 5

I set these permissions in the DataBase properties. I checked all db_owner, db_rightaccess....etc.

But, still the same...

also made Method=direct instead of Cursor, but of no use.

Should I need to run any grant permission script or alter the script and create the Database object again?

I haven't checked the tablespace yet...

G_identitya at 2007-7-10 2:13:27 >

# 6

OK, I take that you are not getting any errors while running the database script. When do you see the original error? During setRepo or some other operation? I would also recommend connecting to the database using some client utility and check the database schema. ~Suvesh

suveshsharmaa at 2007-7-10 2:13:27 >

# 7

Its possible that the proxy user (the username you use to connect the repository to the database instance) does not own the database tables--in this case, the "object" table is simply the first. The "attribute" table would be next, then "userobj", "userattr" and so forth.

You might need to create views to act as synonyms/aliases.

naxdorfa at 2007-7-10 2:13:27 >

# 8

Can anybody help me in create views to act as synonyms/aliases?

G_identitya at 2007-7-10 2:13:27 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

IDM with SQL server Error: Cannot find columns for the table...

Web & Directory Servers New Topic

Web & Directory Servers Hot Topic

Web & Directory Servers

All Classified