Main menu

This place is for open discussion. You can keep your ideas, views, opinions or if you are interested to post an article. Also do comment if you would like to see any specific post on ODI or Data Warehouse.

If you want to process any file that is available in other system. So if odi is installed in your local and you want process those remote files then you have to use one agent running on your remote system.

Hi, My question is
PRC_CD,
RT_TBL,
CNDTN_DSCNT_VALUE,
VLD_FRM_DATE,
VLD_TO_DATE are the five columns in target table. Here I am using IKM oracle control append. The problem is when ever I execute the interface there are multiple number of duplicates are appearing. Also I used Truncate true option. This is the problem. Help me out here.

Please provide the actual count you are expecting in target and the count of C$table and I$ table. Go to operator and open Load Data step and insert flow into I$ table step. Better you can send the screenshot to mail@bhabaniranjan.com
Thanks

For 1st one: You have to make the dml operation for all interface in one transaction and at the end you have to commit that is after 10th interface.

For 2nd one. You have to delete the drop temp table step from the LKM, CKM,IKM ( Might be the last step of each knowledge module. Just check it once from your side ). So that when ever you will restart the session all records will be available in your temp tables. At the same time you have arrange the transaction for INSERT ROWS STEP (i.e. I$ to Target Table). So that this transaction wont be executed.

Please use one KM for all 5 interface and set the commit to false in each interface. In the last interface set the commit to true. It should work. Let me know how is it going or else i will post on this.

i am trying to load data from flat file to oracle data base.
date format in file is DD-MON_YYYY
how can i give date format in interface in odi.
i am using to_date() funtion in interface.
i am getting invalid date format error.

1. Is it mandatory to install weblogic in odi 11g?
2. What is the main purpose of weblogic?
3. Since We r using 10g for longtime, wan to understand main advantages of 11g compared fo 10g and is it easy to upgrade?

MY oracle one SERVER NAME IS REPA,
ANTHOER oracle SERVER NAme IS MISREPL both are in different servers. and i am using LKM oracle to oracle(db link).
ODI-1228: Task INT_DBLINK (Integration) fails on the target ORACLE connection STG.
Caused By: java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified
i am unable to access synonym.please help me.

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:662)

Manohar, you can create multiple work repository for single master repository. So there is no specific number. All work repository will use information stored in master repository (topology, agents etc). And projects are stored in work repository. So you can not access project stored in work repository A inside WR B. You need to import /export the project to other WR.

I am new to ODI.Can you please tell the procedure to create physical and logical schema with snapshots and what are all the initial steps to create a transformations in ODI11g starting from the basic steps. I heve searched in many websites but couldn’t get the enough details. Thanks in advance.

If interface 6 fails then you have to start it manually from step6. Then the flow will move forward.
If you are using loadplan then you must have option to restart from different steps.

For rollback: If you are using one KM for all interface then select the dml operation in one transaction for your KM and commit the same in the last interface.So even if any interface fails there wont be any data loaded to the target.

Manohar, you can exploit temporary interface in different ways which you cannot do in a normal interface. You use temp interface as a source for other interface which never happens in normal interface. You can convert a complex query into temp interface and use it as inline view in other interface. Here you can temporary tables aswell.

Good Afternoon Sushree.
Make your target table empty. So that you can see whether the records got inserted or not. If you want to update the records in target table then select IKM Sql Incremental update KM.

I have created a View on a table and for the first time i executed the view with out CDC ,
all the records from source view to target table got transferred successfully and after that i added CDC on that view and added a row in source table
and the respective view captured the new row ,
and now J$ table captured that record and when i executed that intefrface with CDC it worked . and i have deleted a row in source table and the row got deleted in
respective view but J$ table didn’t captured and when i executed nothing got deleted in target table , and fater i tried in updation the filed in a row but not
reflected in J$ view.

Today i have tried to implement CDC on Views , i have imported the JKM which you have provided me , i have developed interface by dragging view in source and table in target , i have executed it before checking the Jounalization data only box , all records from source to target transferred successfully , now i have checked the Jounalization data only box and i have added a new row in source from backend then immeadiateley it got reflected in view and i executed that interface again then i can see the new row in target also , this is because of CDC on View and i have done updation also , it worked successfully , but when i delete a row in source and execute that interface it is not working .

1st question will be : Are you inserting/updating/deleting thru view or table ? If its view then thats fine. But if its on the base table then your trigger is not going to work since yo have created on the view (instead of). Now your question will be, how it is working in this case (for insert and update not for delete). Right ? its because you have used IKM incremental which is updating the target table based on your key column. It means your instead of trigger is not in use at all. Thats why your delete is not going work.

So the resolution which is coming to my mind is a materialized view. I will try to post on this soon.

Already i told you before CDC on views in my Project and i explan below what is the process is going on so can you provide me any help.
what can i do for instead of every day truncate & load..and they want only insert and updated records only.
my turbo image source file was already have updated file so we i can start my process can you plz tell me ….

There loaded the data from turbo image to ‘X’ schema ( same naming tables ) of ms sql server its a jst truncate & load.
After they are creating views for X schema tables and moving(Copy what ever the data in the x schema that data will be in view in y schema ) to another schema ie ‘Y’ using procedures.
like create schema, Dest Schema, Get_Src schema,Genate views and Generates indexes on tables of ‘y’ schema and again all things done & loaded into ‘ y’ schema only….
( like: ie act as a Source & Target )
and created view on ‘X’ schema tables in ‘y’ schema , those views are used asa source and load into y schema tables.
So, at last there get the table from the ‘y ‘ schema and also loading into the ‘y’ schema in Ms sql server,

They told me like you don’t implement on Turbo image technology ( Source )
bcz its a updated file and it’s truncate and load every day.its taking long time for execution and its every time it loads truncate and load.
So you will implement CDC ON another place.
one more thing is, They loaded data from turbo image to ‘x’ schema of Ms Sql server.. using LKM Sql to mssql , IKM sql to sql Append and CKM Sql.
these are customized KM’s…….and next level is ‘y’ schema to ‘y’ schema
In y schema have the view of x schema as source and loading into y schma target table.
now where i can implement CDC

we are implementing CDC on
my Source is Turbo image and Target is ms sql server
But we don’t have a JKM for Turbo image, So what i should do this situation.
if i want to use customize the JKM, How it write could you pls tell me steps ?
which LKM , IKM’s are impot ?
after importing KM’s In mapping level Flow tab any conditions i have to give ( Target level )?

And one more information is,
There loaded the data from turbo image to ‘X’ schema ( same naming tables ) of ms sql server its a jst full load.
After they are copied (moving) data ( same Tables with data ) from’ X’ schema to ‘Y’ schema in Ms sql server using procedures.like create schema, Dest Schema, Get_Src schema,Genate views and Generates indexes on tables of ‘y’ schema and again all things done & loaded into ‘ y’ schema only….
( like: ie act as a Source & Target )
and created view on ‘X’ schema also, those tables are used in some packages according to the requirement and mostly using ‘y’ schema tables for mapping and everything…
So, at last there get the table from the ‘y ‘ schema and also loading into the ‘y’ schema in Ms sql server,

Now, Client Requirement is implement CDC on Existing projects, ( Above Process already developed by some one and now we are doing support and implemening CDC on that )
Where can i implement the CDC process on turbo image ( But turbo image don’t have JKM ) (or) ‘x’ Schema (or) ‘y’ schema ?

They told me like you implement on Turbo image technology ( Source ) only bcz its a full load its taking long time for execution and its every time it loads truncate and load.
Other than CDC any option is there for inserting/ update and delete ……..on turbo image source technology.
one more thing is, They loaded data from turbo image to ‘x’ schema of Ms Sql server.. using LKM Sql to mssql , IKM sql to sql Append and CKM Sql.
these are customized KM’s…….if any customized JKM for turbo image will work (or) any existing JKM’s are supports turbo image technology…
how to write can anyone guide me.

Hi,
We have 5 interfaces in package, while executing 3rd interface got failed then I found the problem and rectified but thing is I need to execute the package from that step onwards, how can I do this? Please help me. Thank you in advance.

Hi Bhabani,
I am using ODI 10.1.3 version. I tried to restart the failed interface as per your above response, but I did not find that option. Please let me know where I need to find that option in my version.

1) How you handle without knowledge module and through query in SCD?
2)What are the problems did you faced while loading excel file to table?
3) We have 7 or 8 interfaces in a package but at 5 stage interface got failed but while re executing we need to execute from 5 stage onwards. How it is?
4) What is the information we have in master repository?
5) Can we have more than one master repository?
6) How many work repositories you are maintaining in your project?
7) What are fact tables and dimension tables occurred in your project?
8) What is the format of down loaded components like interfaces, packages, etc
9) How system knows that is existing record where it will check either source side or target side?

1) How you handle without knowledge module and through query in SCD?Without KM ? hmm probably you have to go for generic process. (IKM incremental and delete target row where tgt.key_col not in source_key_col)
2)What are the problems did you faced while loading excel file to table?Not yet. Just only invalid fetch size error and buffer string error.( already discussed in my blog)
3) We have 7 or 8 interfaces in a package but at 5 stage interface got failed but while re executing we need to execute from 5 stage onwards. How it is? better go for load plan if the design have no looping.
4) What is the information we have in master repository?
what ever you can see in topology.
5) Can we have more than one master repository?yes you can have.
6) How many work repositories you are maintaining in your project?Six Repo.
7) What are fact tables and dimension tables occurred in your project?
8) What is the format of down loaded components like interfaces, packages, etcNaming Convention ??
9) How system knows that is existing record where it will check either source side or target side?Not Clear about your requirement.

While trying to view data for src_sales_person datastore, i am getting the errors as follows:

Line 0: ODI-40469: Value was incorrect for column 3: Could not transform 15/01/2001 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 1: ODI-40469: Value was incorrect for column 3: Could not transform 22/02/1999 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 2: ODI-40469: Value was incorrect for column 3: Could not transform 20/04/2000 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 3: ODI-40469: Value was incorrect for column 3: Could not transform 10/06/1988 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 4: ODI-40469: Value was incorrect for column 3: Could not transform 28/02/1988 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 5: ODI-40469: Value was incorrect for column 3: Could not transform 24/09/1992 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 6: ODI-40469: Value was incorrect for column 3: Could not transform 14/03/1995 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 7: ODI-40469: Value was incorrect for column 3: Could not transform 11/03/1999 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 8: ODI-40469: Value was incorrect for column 3: Could not transform 18/03/2003 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 9: ODI-40469: Value was incorrect for column 3: Could not transform 29/05/2001 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 10: ODI-40469: Value was incorrect for column 3: Could not transform 29/05/2000 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 11: ODI-40469: Value was incorrect for column 3: Could not transform 12/08/2001 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 12: ODI-40469: Value was incorrect for column 3: Could not transform 25/08/1992 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 13: ODI-40469: Value was incorrect for column 3: Could not transform 30/01/1992 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 14: ODI-40469: Value was incorrect for column 3: Could not transform 28/02/1994 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1
Line 15: ODI-40469: Value was incorrect for column 3: Could not transform 28/03/1993 00:00:0 to date using pattern dd/MM/yyyy hh:mm:ss at position 1

Yes you can create multiple master repository. But keep in mind that you cannot establish any relation between master repositories as they are not bound to each other. Let me know your requirement so that i can suggest whether it is productive to create multiple master repository or not.

Hi Bhabani,
I have a query on error handling on odi.Actually I want to invoke a .sh script using OdiOsCommand and I get an error like this:-
ODI-30038: OS command returned 127.
Could you please tell me why this is happening(or what is its meaning)?
and please show me the way how can I handle this type of error in odi(as for another .sh file I am getting an error like this ODI-30038: OS command returned 1).

Thanks
Anindya

Error Details:

com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30038: OS command returned 127.
at com.sunopsis.dwg.tools.OSCommand.actionExecute(OSCommand.java:294)
at com.sunopsis.dwg.function.SnpsFunctionBase.execute(SnpsFunctionBase.java:276)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1889)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1066)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:662)

Arjun, optimization context used to figure out how it is going to build its flow tab. For example you have one data server for source and target in dev. Then the flowtab will use the IKM only not LKM. Now you generated the scenario and promoted to other env. Suppose in that env you have two dataserver for source and target. Guess what will happen. Your promoted scenario will not work and it will fail. Because, you have two dataserver and the flow tab will be needing one LKM and one IKM which is not available in the scenario.
Thats why before generating scenario you need to under stand the topology information of other env. Then generated the scenario accordingly.

How r u doing,
Recently i started working on ODI earlier i used to work in OBIEE

My question :
I am trying to load the data from File to ORACLE Database and give all the proper datatype in datastore and when i was trying to run the interface below error i am getting
and we are date column in the table. Could you please resolve this issue

Line 0: ODI-40469: Value was incorrect for column 3: Could not transform 201002230000000 to date using pattern ‘YYYYMMDDHH24MISS’ at position 1
Line 0: ODI-40469: Value was incorrect for column 4: Could not transform 201102220000000 to date using pattern ‘YYYYMMDDHH24MISS’ at position 1
Line 0: ODI-40469: Value was incorrect for column 4: A ParseException occured saying Unparseable date: “201102220000000”

In the Topology Tab, regarding to the Physical (Schema) Architecture in Hypersonic SQL Technology, how will I create the HSQL_LOCALHOST_20001_Default? If it is a schema, what are the procedures to create this schema? same goes with HSQL_LOCALHOST_20001_Default?

I have installed RFI(Retail Financial Integration) for EBS to RMS integration. RFI installation gave me few readymate builds in ODI like Agent, Interface, Procedure and etc.

In my project we will be having some other technology interfaces. My quetion is
Can I use the same agent which I got with RFI intallation (as mentiiond above) for other interface? Or Should I need to create a new agent for my other interface ?
Please suggest me better way to proceed

I am writing data from a database table to flat file using odisqlunload. However the problem is that for some tables the count in source table and file is same, but for some file contains more no of rows. Any idea as to why this is hapenning?

I checked the file and found that there are duplicate records that are being written to it. However this is happening for only some tables, for others it is working fine. Can you suggest what is the problem?

how to CDC on synonym in ODI ?
As I am using ODI version 11.1.1.
After adding Add to CDC, I click on Start Journal. It gave primary key error. Then I have added a Primary key in ODI->MyModel->reverse enginered synonym->Constraints.
After that I have clicked on start journal then gave error as below
“ODI-1228: Task FND_LOOKUP_VALUES (Journalizing) fails on the target ORACLE connection EBIZ DS.
Caused By: java.sql.SQLException: ORA-38818: illegal reference to editioned object APPS.FND_LOOKUP_VALUES”
Can you please tell me how to resolve above error ?

Hi,
Can you please tell me detailed steps how to configure DB2/400 with ODI.
In one of the site they mentioned as it can be achived by using some jt400.jar file. But i dont have detailed information on it.

I have created a simple interface that is from ORACLE to DB2/400
I have imported LKM as LKM SQL to DB2400(CPYFRMIMPF)for source (ORACLE)
In the above LKM description it says “An ODI Agent must be located on the AS/400”. I not sure how to achive this point.

I am trying to access a complex file from local server. I have placed the complex file and Schema file in same path.

When i create data server for complex file, the connection was successfull.

When i tried to create Physical Architecture for the same, i couldn’t see the Element name in drop down.

When i tried to reverse engineer that in Model i am getting the below error.

Error:
java.sql.SQLException: ODI-40865: No DTD named /home/oracle/safaricom/bank/cashmanagement/SCB/in/SWIFTM940.xsd was found so the XML schema could not be created
at com.sunopsis.jdbc.driver.xml.SnpsXmlSchema.(SnpsXmlSchema.java:466)
at com.sunopsis.jdbc.driver.xml.SnpsXmlSchemaManager.createNewSchema(SnpsXmlSchemaManager.java:296)
at com.sunopsis.jdbc.driver.xml.SnpsXmlSchemaManager.getSchemaFromProperties(SnpsXmlSchemaManager.java:273)

But the same works fine if i place the file in Local machine (Desktop, not in server).

We have clob data types in source in that we using KMs as LKM SQL TO ORACLE,IKM SQL CONTROL APPEND
when i am running the interface it failing with following error
Caused By: java.sql.BatchUpdateException: ORA-00942: table or view does not exist.
• what ever the clob columns not mapping to target then the interface executing successfully. Is there any Knowledge module customization required to achieve this, we are using ODI(11.1.1.5).
when i am testing it in 11.1.1.7 it executing successful, but our production environment is in 11.1.1.5.we have to do in this version only.
could you please suggest us.

I am loading a data from csv file to oracle table through odi,from Winscp we are extracting the files to odi for integration,the prblm is after loading into the table some blank boxes are coming in between data,when i try to copy those blank boxes its look like ���� ,after generating the report also it appearing like that only,why this boxes are coming how can i resolve this prblm plss help me to get over this.

As of now I dont see any such dynamic configuration to build the logic. What you can do is to develop a java based parser to track the delimiter before the file is being processed. Then replace the delimiter with the actual delimiter used in ODI File Data store.
Let me know if it helps.

I hope you are asking about field separator.
Create one array to store the expected list of separators. For instance (‘|’,’$’,’#’,’*’). Scan the incoming file and check the presence of any such separator. If found replace it with the ODI file separator. Take special care about comma in values ( normally comes in string such as comments, about me,text). This is normally surrounded with text delimiter.

Exactly though its bit slower at this moment. Will update you if i come across any other faster approach.

Updates: you can update the field separator in metadata tables before processing the file.
For example.
UPDATE SNP_TABLE SET FILE_SEP_FIELD=’\u007c’ WHERE TABLE_NAME=’YOUR_FILE_DATASTORE_NAME’;
Here \u007c is nothing but pipe and you can update it to \u002c which is a comma.
This way ODI will pick the field separator dynamically before executing the interface.

We are facing an urgent issue in one of our data loads as given below.
We are getting below error when we try to connect to MS access databases through ODI 11g (11.1.1.7)

oracle.odi.runtime.agent.invocation.InvocationException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:265)
at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:780)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:584)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$10(SnpsDialogTestConnet.java:581)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$5.doInBackground(SnpsDialogTestConnet.java:558)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$5.doInBackground(SnpsDialogTestConnet.java:1)
at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)
at java.lang.Thread.run(Thread.java:662)

The error is signalled when we test the connection with the standalone agent through topology. fo local ( no agent ) we do not get this error.
We checked the JAVA version used in ODIParams.bat and changed it to 32-bit java and we have also created the DSNs usong 32Bit ODBC drviers.

I am facing issue to populate an ODI variable value into target oracle table column in an interface.
I have assigned variable as alphanumeric datatype and my target oracle table column is of date datatype.

Thanks for the reply.I did the mentioned conversion using to_date function but its not working.

I am providing background of the overall procedure that i followed.

I have declared a variable runtime and its datatype is alphanumeric.
The refreshing query for variable is select to_char(sysdate,’dd-mon-yy’) from dual.
I am getting the variable value as 21-jan-15.
Now I have an oracle table column with datatype date where i want to populate this variable value.
Here I am using to_date(‘#odi_test.runtime’,’dd-mon-yy’) converson function, but getting error on execution of interface while inserting rows in table.

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:662)

How does odi read files from remote server.In my case i have to read files from linux server. I have installed in windows. when i was trying to create datastore for files then it shows directory path not found.

I have requirement to process files those are resides at remote location (file topology server). When I am trying to accessing those using Jython script it is erroring out. But when I map that drive to local PC and try to execute the procedure it is working fine. I don’t want to map the drive and wanted to process the file just by giving IP address. Shall it possible? Please respond to this question.

How do you execute this jython script? Is it inside ODI studio or outside ODI studio.
If it is inside ODI Studio, then put that code inside ODI Procedure. While executing the procedure, you select the context and remote agent.

at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:662)
Caused by: Traceback (most recent call last):
File “”, line 11, in
File “C:\oracleodi\oracledi.sdk\lib\Lib\os.py”, line 279, in listdir
raise OSError(0, ‘No such directory’, path)
OSError: [Errno 0] No such directory: ‘\\mshs6290a-cifs.mountsinai.org\\GRPS2\\MSHSSCMDWH\\scm_input_file’

at org.python.core.PyException.fillInStackTrace(PyException.java:70)
at java.lang.Throwable.(Throwable.java:181)
at java.lang.Exception.(Exception.java:29)
at java.lang.RuntimeException.(RuntimeException.java:32)
at org.python.core.PyException.(PyException.java:46)
at org.python.core.PyException.doRaise(PyException.java:219)
at org.python.core.Py.makeException(Py.java:1166)
at org.python.core.Py.makeException(Py.java:1170)
at org.python.core.Py.makeException(Py.java:1174)
at os$py.listdir$27(C:\oracleodi\oracledi.sdk\lib\Lib\os.py:280)
at os$py.call_function(C:\oracleodi\oracledi.sdk\lib\Lib\os.py)
at org.python.core.PyTableCode.call(PyTableCode.java:165)
at org.python.core.PyBaseCode.call(PyBaseCode.java:131)
at org.python.core.PyFunction.__call__(PyFunction.java:317)
at org.python.pycode._pyx55.f$0(:13)
at org.python.pycode._pyx55.call_function()
at org.python.core.PyTableCode.call(PyTableCode.java:165)
at org.python.core.PyCode.call(PyCode.java:18)
at org.python.core.Py.runCode(Py.java:1204)
at org.python.core.Py.exec(Py.java:1248)
at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)
at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)
… 19 more

The error is itself self explanatory. Agent is not able to access the directory. Server 10.21.123.104 should see the path in 10.9.10.68. Actually the agent should have been in 10.21.123.104.
Are they both in LAN?

Yes. Both PC’s are in LAN. When I map the drive on server (10.21.123.104) and use that drive in Jython scripr (e.g O\…) then it is working. But I don’t want to map the drive. It should be accessed through agent or by placing path (e.g. IP/folder). Agent is on 10.21.123.104 server only.

I am using IKM (Oracle Incremental Update) , LKM (SQL to Oracle), No CKM. Whenever my interface submitted and if it has any duplicate rows then it gets error out at (Update existing rows ) procedure. My requirement is if there are any duplicate rows then it should delete one row automatically or process only one row. The C$ and I$ table has same count of records (12022). The error is occuring when I$ table start execute update existing rows procedure when is part of IKM.

Hello Bhabani,
Can you please guide on following?
If the table definition in database changes for e.g. the column “salary number(4)” changes to “salary Number(10)”.
Do I have to reverse engineer all the models(which are using the table) again and create/refresh new datastores in order to fetch its new defination in ODI studio?

Hi,
I need help regarding ODI 11g,
I am using MSSQL Server 2012 database for ODI,
in one of target table i have given id_key column as an identity, while performing SCD Type2 i got stuck in error “updating existing row”,

and even i tried to use mssql server sequence but i am unable to use in odi..

i am using ODI 12C how to import xml file as source and target file as oracle
while creating data server connection test
it shows odi-26039

va.sql.SQLException: ODI-40933: Unable to build XSD from DTD

how to import all the xml file from local machine in to odi 12c and load the tables into oracle

please find bello error i have get while test connection of data server
java.sql.SQLException: ODI-40933: Unable to build XSD from DTD.
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1243)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:203)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$1100(SnpsDialogTestConnet.java:62)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:400)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:396)
at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: ODI-40933: Unable to build XSD from DTD.
at com.sunopsis.jdbc.driver.xml.SnpsXmlDTD.initialize(SnpsXmlDTD.java:374)
at com.sunopsis.jdbc.driver.xml.SnpsXmlDTD.initialize(SnpsXmlDTD.java:480)
at com.sunopsis.jdbc.driver.xml.SnpsXmlDTD.(SnpsXmlDTD.java:154)
at com.sunopsis.jdbc.driver.xml.SnpsXmlSchema.(SnpsXmlSchema.java:560)
at com.sunopsis.jdbc.driver.xml.SnpsXmlSchemaManager.createNewSchema(SnpsXmlSchemaManager.java:321)
at com.sunopsis.jdbc.driver.xml.SnpsXmlSchemaManager.getSchemaFromProperties(SnpsXmlSchemaManager.java:298)
at com.sunopsis.jdbc.driver.xml.SnpsXmlDriver.connect(SnpsXmlDriver.java:143)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:412)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:385)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:352)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:331)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:110)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:228)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
… 1 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 8
at oracle.xml.parser.v2.DTD2SchemaBuilder.getElementDecls(DTD2SchemaBuilder.java:175)
at oracle.xml.parser.v2.DTD.convertDTD2Schema(DTD.java:585)
at com.sunopsis.jdbc.driver.xml.SnpsXmlDTD.initialize(SnpsXmlDTD.java:370)
… 19 more

at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:745)
Caused by: Traceback (most recent call last):
File “”, line 44, in

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)

at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1110)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2251)

at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2192)

at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:347)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at org.python.core.Py.JavaError(Py.java:455)
at org.python.core.Py.JavaError(Py.java:448)
at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:177)
at org.python.core.PyObject.__call__(PyObject.java:355)
at org.python.core.PyMethod.__call__(PyMethod.java:215)
at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)
at org.python.core.PyMethod.__call__(PyMethod.java:206)
at org.python.core.PyObject.__call__(PyObject.java:397)
at org.python.core.PyObject.__call__(PyObject.java:401)
at org.python.pycode._pyx5.f$0(:50)
at org.python.pycode._pyx5.call_function()
at org.python.core.PyTableCode.call(PyTableCode.java:165)
at org.python.core.PyCode.call(PyCode.java:18)
at org.python.core.Py.runCode(Py.java:1204)
at org.python.core.Py.exec(Py.java:1248)
at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)
at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)
… 19 more
Caused by: java.sql.SQLException: ORA-06564: object DAT_DIR does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1110)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2251)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2192)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:347)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:175)
… 33 more

Hi Pavan,
Could you please explain your scenario?
what I can get from your question is:
“how load the multiple files with different structures in odi”
Ans: Create different models for them and load, its simple what else are you looking for.
Ques: 5o files are there how 25 files load to first day and next 25 files another day load to target
Ans: Assuming the files have the same structure and you just want to schedule them on different day.
Follow this:
first 25 files, develop a loop in odi to process the first 25 files and later archive them to some location.
Next day your directory will have the remaining 25 files , process them.
For the above processing job, develop a scenario and schedule it using an Agent, the processing will take care automatically.

I don’t have an infrastructure set like this, with 11.1.1.5 as the ODI version and 12c as the database.
However if you look at the way how ODI is designed, it is supposed to create Master and Work Repository in any DB that follows the standard RDBMS rules.
Moreover 12c DB has not changed the way how jdbc driver will connect to the schema, though the internal concepts have changed.
Please try to connect to the 12c DB using your ODI, I think it should work.

I am getting below error.
java.sql.SQLException: IO Error: Got minus one from a read call
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)
at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1258)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:207)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$1300(SnpsDialogTestConnet.java:65)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:407)
at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$6.doInBackground(SnpsDialogTestConnet.java:403)
at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)
at java.lang.Thread.run(Thread.java:745)

Connection details are as follows:
jdbc:odi_ssl_oracle:thin:@//160.34.9.118:1521/EBSTRN1.compute-a419517.oraclecloud.internal

We are loading data from flat file to oracle data base by using attunity connections in SSIS, data is successfully loading into oracle 11G database, we we executed the same package with oracle12C data base data is not loading completely, only small amount of data is loading and after that data s not loading but it keep on executing, Can some one please help me here.

We are loading data from flat file to oracle data base by using attunity connections in SSIS, data is successfully loading into oracle 11G database, we we executed the same package with oracle12C data base data is not loading completely, only small amount of data is loading and after that data s not loading but it keep on executing, Can some one please help me here.

Could you provide more details on this. SSIS attunity connections will call and execute the same package that Oracle DB executes, this is interesting that the data is loaded using remote calls from SSIS, but not directly, please provide the details.

All scheduled jobs are linked with current email (if any job will failed get an failure email), But I want to change the current email to new email.

using Procedure (Jython code) they did, inside procedure global variables (Email_receipnt, local_host, Local_Port like..) but now how to change emailid in Prod.

Is there any option, If I update the variables & Procedures in Dev that will reflect in Prod ?

Can you please advise me.

Note:-
1). I have changed the variable Default value: new@yahoo.com & Updated the Table as well in prod.
2). I have created the procedures using Jython code (notify/fail/finish like…) with update variables.

Hello, please I have a new data source. I tried to insert actual column from the source into the target table which also has actual column using odi. But it not working. Please I need your help.
Thanks.

So to map each attribute I used predefined odi function EXTRACT(,) within expression builder. For Ex :

EXTRACT(XMLTYPE(XML_DATA),’//tag1/tag2/tag3/tag4/tag5/tag6/text()’) .

However my xml contains multiple tag6 whose value I am trying to fetch . when using this function I am able to load the value present in tag6 to the target table. However, it is picking all the tag6 values and are appending them.

Could you please tell me how to get the separate values to be inserted into the target table.

I serach few links and got to know that we can use XMLSEQUENCE . but not sure how to use that. Could you please shed some light so that I can achieve the desired result.

Disclosure

The views expressed on this blog are those of the author and do not necessarily reflect the views of Oracle. All content and s/w code on this site are offered without any warranty, or promise of operational quality or functionality.