Data not loading after Microsot SQL server 2000 upgrade to MS SQL srvr 2005
628001Mar 12 2008 — edited Mar 12 2008We are using inetdae7 driver from many years to connect to Microsoft SQL Server 2000 database (operating system Windows 2000), wherein the data load was fine. The source was Microsoft SQL Server 2000 and target was IBM DB2 ver 8.1.
Recently in the source server the operating system was upgraded to Windows 2003 and database version to Microsoft SQL Server 2005. After this migration there has been no change in ODI code but data is not being loaded to work table itself in the job. It is not giving any error but in the logs , data loaded to work table (C$ table) is coming as 0. Please let us know what may be the issue (do we need to upgrade the JDBC driver ?)
This problem is typical. There are two databases in Microsoft SQL Server (database 1 and database 2). In topology, both are defined as two physical schemas under the same Physical server. Schema representing database 1 is the default schema under the Physical server.
Only tables are present in database1.Only views are there in database2.These views are based on tables of database1.When the query in the interface is against database1, the number of records loaded to work table is 0. When the same query is run against the model of database1 in Designer by right clicking and checking the data then it is returning records :(
However, when the query in the interface is against database2 the data load is fine. When the query is join between database1 and database2 tables/views, the data load is fine.
Now this issue has come only after upgrade of Operating system and microsoft SQL Server edition in the source, there is no change in the code. Please provide your valuable comments. Please treat this as urgent.