cannot create table error 1951

preethi · #1 10th August 2010, 12:47

hi all,
i am trying to create a table in a customized package, but while i run the session "create table" it is displaying the error as " cannot create table (erro 1951)". The problem is recent beacuse i have created tables in that package previously.

after entering details in table definition...i have run convert to runtime data dictionary, but no entry is found in table ttadv502 table..

how can i locate the root cause for this error.

Any ideas are welcome
thanking you in advance

bdittmar · #2 10th August 2010, 13:08

Quote:

Originally Posted by preethi

hi all,
i am trying to create a table in a customized package, but while i run the session "create table" it is displaying the error as " cannot create table (erro 1951)". The problem is recent beacuse i have created tables in that package previously.

after entering details in table definition...i have run convert to runtime data dictionary, but no entry is found in table ttadv502 table..

how can i locate the root cause for this error.

Any ideas are welcome
thanking you in advance

Hello,

from another post:

The other possibility is to contact Informix support. ... Drop original table error 1951.

Regards

raghava sriram · #3 11th August 2010, 08:05

hi,

you are getting this error only when you run 'create table' session or also while trying to access the db.
Please let me know

Regards,

lebowski · #4 11th August 2010, 12:06

Hello,

sounds like a permisssion problem. Informix Error 951 means

-951 User username is not known on the database server.

Regards,

lebowski

preethi · #5 12th August 2010, 06:26

Quote:

Originally Posted by raghava sriram

hi,

you are getting this error only when you run 'create table' session or also while trying to access the db.
Please let me know

Regards,

i am getting error in both cases. while using 'create tables' & ttaad4100

raghava sriram · #6 12th August 2010, 07:07

Preethi,

Please check your username and password for the informix database. since error 1951 states : Incorrect password or user where informix is not known on the database server.

Regards,

preethi · #7 13th August 2010, 14:22

Sriram,

I have done this using 'bsp' login. Will bsp login also have the same issue?

Han Brinkman · #8 13th August 2010, 17:54

Yes,

These actions are performed with the account which you can find in the inf_groups file. Check which account is in that file and make sure the crypted pw matches with the real one.

Regards,
Han

raghava sriram · #9 14th August 2010, 04:34

Preethi,

Yes, user 'bsp' can also have the same issue. As 'han' said check for that account in the info_group file and make sure the pw matches with the current one.

Also, you can check with your user id. since you are creating the table in customized VRC, so you can also create the table with your user id.

Regards,

raghava sriram · #10 14th August 2010, 04:36

Preethi,

Yes, user 'bsp' can also have the same issue. As 'han' said check for that account in the info_group file and make sure the pw matches with the current one.

Also, you can create the table with your user id and check . since you are creating the table in customized VRC.

Regards,