Hi,

I get error 1922 when I try to create a table using "Create Table(ttaad4230m000)".

I did search all the threads posted here on this topic and I did not find any solution.

Can anyone help me?

Regards

Refer to the threads -

Error 1922 During Baan/Informix Login: Cannot get name of current working directory. (http://www.baanboard.com/baanboard/showthread.php?t=8367&highlight=1922)

Cannot create table(error 1922) (http://www.baanboard.com/baanboard/showthread.php?t=8366&highlight=1922)

Also check if you have properly configured the Oracle Storage parameters and if the tablespaces are create in Oracle.
cat $BSE/lib/ora/ora_storage_param
*:320:T:TABLESPACE DATA01_320 PCTFREE 5 INITRANS 3
*:320:I:TABLESPACE INDEX01_320 PCTFREE 5 INITRANS 3
*:*:T:TABLESPACE DATA01 PCTFREE 5 INITRANS 3
*:*:I:TABLESPACE INDEX01 PCTFREE 5 INITRANS 3

Hi NP,

I have checked the oracle storage parameters it has the below settings (Only 2 lines)...
*:*:T:group:0214:5:TABLESPACE LNDATA PCTFREE 5 INITRANS 3
*:*:I:group:0214:5:TABLESPACE LNINDEX PCTFREE 5 INITRANS 3

Is it OK?

2. How to check if the table spaces are created in Oracle?

Regards,

2. How to check if the table spaces are created in Oracle?

Check in Oracle:

select * from v$tablespace ;


TS# NAME INCLUDED_IN_DATABASE_BACKUP BIGFILE FLASHBACK_ON
-------------------------------------------------------------------------------------------------------
0 SYSTEM YES NO YES

1 UNDOTBS1 YES NO YES

2 SYSAUX YES NO YES

3 TEMP YES NO YES

4 USERS YES NO YES

6 PERFSTAT YES NO YES

7 DATA01 YES NO YES

8 INDEX01 YES NO YES

9 TOOLS YES NO YES

Hi NP,

I was not getting this error earlier. We did some performance tuning and kept the following Objects in shared memory.

Load following objects in Shared Memory
ttstp to ttstpzzzzzzzzz
ttdsk to ttdskzzzzzzzzz
ttdll to ttdllzzzzzzzzz

Is this a problem by any chance?

Regards,

HI NP,

If you can carefully read the oracle storage parameters that I posted here....you will find something with 'group:0214' in it which is not there in your settings.

*:*:T:group:0214:5:TABLESPACE LNDATA PCTFREE 5 INITRANS 3
*:*:I:group:0214:5:TABLESPACE LNINDEX PCTFREE 5 INITRANS 3

When I removed that setting it worked fine. Can you please let me know what that setting is for? Or please send me some document which talks about these settings.

You help is highly appreciated.

Thank you so much for your time and valued suggestions.

Regards,

Those are the Oracle driver parameters
$ cat $BSE/lib/ora/ora_driver_param
*:*:T:group:0214:0:
*:*:I:group:0214:0:
Refer to the Oracle Database Driver Technical Reference Manual for more info.

BaanERP porting set 7.X
This section describes the configuration file format as used by the porting sets 7.X. Although these porting sets are capable of handling the configuration file as used by older porting sets, You must use the new configuration files.
File Format: $BSE/lib/ora/ora_driver_param
The driver parameter file provides a means to influence the behavior of the database driver on a per table/index basis for:
The ownership of the database tables (See Chapter Database Security).
The query generation (See Chapter Query Tuning).
The refresh time of the record cache (level-1 mode only).
The following is an example of an entry in the driver parameter file:
*:*:T: group:0214::
In this example, the database driver will create tables owned by a BaanERP group, and will use the iterative technique during the query generation. A driver parameter file is defined for each database driver. The storage file for the BaanERP Oracle database driver is called ora_driver_param and is located in the Windows NT directory %BSE%\lib\ora or the UNIX directory
$BSE/lib/ora.
If the ora_driver_param file does not exist, the driver will fall back to the functionality of porting set 6.2a.X, and use the ora_storage file to retrieve the required information. The file should consist of zero or more entries, each consisting of several fields separated by colons. The format of an entry in the storage file is as follows:
(primary key in bold)

<table/module specification> : <company number> : <object type> : <group> : <table/index optimization> : <refresh time>

<table/module specification> : <company number> : <object type> : <group> : <table/index optimization> : <refresh time>