novicebaan
24th October 2003, 10:03
hello All,

I was working with the session ttiex1280m000. the export was done completed without any error , But while runing the import session it was giving error
fatal error - 2017 ( bdb_errno 2017) on ttiex186000 in clear_table

fatal error - cannot continue - in ottiex1288 (init.gui)

pl give the solution for the above problem

regs

novicebaan

Djie-En
24th October 2003, 10:18
Hi,

the error 2017 is: Integer value required.
Cause: the specified value must be an integer.
Action: Specify an appropriate integer value, then retry the operation.
Maybe your file (a field value) is corrupt or the tabledefinition is not correct.
Is the error on a specific table? Did you dump the data with a seperator?

sikima
24th October 2003, 15:15
If you have an error 2017, check user password. I have had that problem when I had mismatch between Baan and database user. Also, check your lib\ora dir - ora_users file ...

NPRao
24th October 2003, 21:30
Novicebaan,

To retrieve errors with error codes greater than 1000, subtract 1000 from the error number. The result is the database error code. For example, the error code 1510 represents the database error code 510 (that is, 1510 – 1000).

Here a database error 2017 can be interpreted as -

>oerr ora 1017
01017, 00000, "invalid username/password; logon denied"
// *Cause:
// *Action:

Did you export/import with the same login ?

Sikima, means that you have to reset your Oracle database user password for that BaaN login and regenerate the ora_users file.

dave_23
24th October 2003, 23:37
Check out solution #159165 for this on the Baan support website.

Dave

novicebaan
26th October 2003, 09:23
thanxs for the reply. There was problem with the password.

as suggested by Mr. NPRao

>oerr ora 1017
01017, 00000, "invalid username/password; logon denied"
// *Cause:
// *Action:

Is this a unix command . if "yes" then In which path should i try this .

bye

victor_cleto
26th October 2003, 17:26
This is oracle, not unix.
oerr ora <code> allows you to get a short description of an oracle error code, for further informations check with your dba.

NPRao
27th October 2003, 20:41
novicebaan,
Is this a unix command . if "yes" then In which path should i try this .
You can find the path using the which command in Unix -

>which oerr
/app/common/oracle/product/8.1.7.2/bin/oerr

novicebaan
30th October 2003, 07:55
thanx for the reply