1)For a pre/Post Load Command you have called a procedure.
Procedure is not declared is the error u r getting.
A)U Got to mention the Schema Name in which the Procedure resides.
2)Datatype Mismatch in Toad Date---Number
The Data in the table might have number instead of Date.
Check for the schemas bcoz the same table might contain in the same schema and also in other schemas.
3) ora-24334:
The Data in the table might have number instead of Date.
Check for the schemas bcoz the same table might contain in the same schema and also in other schemas.
3) ora-24334:
No Descriptor for this position in SQL Transfrom (Gives the entire query i.e written in SQL Transform?
A) This error comes If some column of the table has been added/removed in the background i.e in the database, but not reflected in the SQL Transform. you got to remove all the columns from the SQL Transfrom and update the schema again in SQL Transform.
Else Click on Update schema is enough.
Even If you have a query like “SELECT b.sno, b.effdate,b.data FROM scott.b b” in the SQL Transform and the columns that are visible are sno, effdate then you won’t be getting any error.
4) In Flat File Lookup the file i.e we are looking for, in that file definition we don't have to specify the root directory. Instead directly specify the path which is enough.
If you specify both while looking the file the path will come 2 times like C:\C:\.....
which is wrong.
5)A Single Job Server can be configured with multiple repositories and Viceversa.
6)Create a CTL file using SQL Loader .This can be acheived thru dos or Toad.
If you are creating the CTL file thru Toad, at the same time you can load the data into the database also.But Make sure that you already created the table with the necessary structure in the database priorly.
If you want to load the data into the table manually via Dos or thru Data Integrator then
you got 2 use the SQLLDR Command of dos .
SQLLDR USERID=SCOTT/TIGER@ORADB5 CONTROL=D:\A.CTL LOG=D:\A.LOG
If you r using Data Integrator then Use the following command in Data Integrator.
EXEC('D:\BAT','D:\A.CTL',1);
Put the following command in a Batch file.
SQLLDR USERID=SCOTT/TIGER@ORADB5 CONTROL=%1 LOG=D:\A.LOG
%1 is the parameter(D:\A.CTL) i.e coming from the EXEC() command of Data Integrator
7)ORA-01861: literal does not match format string
A) If the datatype in the table is date and you r passing a Varchar2/NUmber datatype then this error will occur.
A) This error comes If some column of the table has been added/removed in the background i.e in the database, but not reflected in the SQL Transform. you got to remove all the columns from the SQL Transfrom and update the schema again in SQL Transform.
Else Click on Update schema is enough.
Even If you have a query like “SELECT b.sno, b.effdate,b.data FROM scott.b b” in the SQL Transform and the columns that are visible are sno, effdate then you won’t be getting any error.
4) In Flat File Lookup the file i.e we are looking for, in that file definition we don't have to specify the root directory. Instead directly specify the path which is enough.
If you specify both while looking the file the path will come 2 times like C:\C:\.....
which is wrong.
5)A Single Job Server can be configured with multiple repositories and Viceversa.
6)Create a CTL file using SQL Loader .This can be acheived thru dos or Toad.
If you are creating the CTL file thru Toad, at the same time you can load the data into the database also.But Make sure that you already created the table with the necessary structure in the database priorly.
If you want to load the data into the table manually via Dos or thru Data Integrator then
you got 2 use the SQLLDR Command of dos .
SQLLDR USERID=SCOTT/TIGER@ORADB5 CONTROL=D:\A.CTL LOG=D:\A.LOG
If you r using Data Integrator then Use the following command in Data Integrator.
EXEC('D:\BAT','D:\A.CTL',1);
Put the following command in a Batch file.
SQLLDR USERID=SCOTT/TIGER@ORADB5 CONTROL=%1 LOG=D:\A.LOG
%1 is the parameter(D:\A.CTL) i.e coming from the EXEC() command of Data Integrator
7)ORA-01861: literal does not match format string
A) If the datatype in the table is date and you r passing a Varchar2/NUmber datatype then this error will occur.
8)BODI -1111340 ERROR ……….OCI.dll file cannot find.
Go to \Oracle\Ora92\Network\Admin\Tnsnames.ora
Open the file and check for SID=connection string thru which u r logging.
If not available over there add the SID=Connection String, Under the
**Connect Data**
9)I have a custom function that suddenly fails. The function is called in a script transform, passing global variables as parameters. The error msg says "Incorrect syntax near......due to error 70401" and it lists the function call w/ a lot more param values than actually defined in the function.
Sol) Might be using the D.I version 11.7.0.X, So please upgrade to 11.7.3.X.
