Dear All,
I am using the oracle transparent gateway connectivity with sql server
using tg4msql,as far as
settings are concerned those were set and Connectivity is working Fine,
and getting the response
from that server.
here is description what I done as:-There is a View on Sqlserver which
is Join of 6 tables and have
data around 1 million in 2 tables and 0.5 million in rest of the
tables, as the Query for creating
sqlserver view is given below:
CREATE view Account_anila_t est as
SELECT ......(around 50 Columns)
FROM GE_Init.dbo.Per son INNER JOIN
GE_Init.dbo.Kon to ON GE_Init.dbo.Per son.Person_ID =
GE_Init.dbo.Kon to.Person_ID INNER JOIN
GE_Init.dbo.Pro dukt ON GE_Init.dbo.Kon to.Produkt_ID =
GE_Init.dbo.Pro dukt.Produkt_ID LEFT OUTER JOIN
GE_Init.dbo.CRM Konto ON GE_Init.dbo.Kon to.Konto_ID =
GE_Init.dbo.CRM Konto.Konto_ID LEFT OUTER JOIN
GE_Init.dbo.cal cKontoOBSdt ON GE_Init.dbo.Kon to.Konto_ID =
GE_Init.dbo.cal cKontoOBSdt.Kon to_ID LEFT OUTER JOIN
GE_Init.dbo.cal cKonto ON GE_Init.dbo.Kon to.Konto_ID =
GE_Init.dbo.cal cKonto.Konto_ID
WHERE (GE_Init.dbo.Ko nto.SlettetKont o = 0) AND
(GE_Init.dbo.CR MKonto.MarkertF orSletting = 0
OR GE_Init.dbo.CRM Konto.MarkertFo rSletting IS NULL)
Now,I made a table in oracle adjacent to sqlserver View and Inserted
data as:
INSERT INTO ACCOUNT_TEST11( .....)
SELECT .............
FROM Person@dbl_getg c1 a INNER JOIN
Konto@dbl_getgc 1 b ON a."Person_ID" = b."Person_ID" INNER JOIN
Produkt@dbl_get gc1 c ON b."Produkt_ID " = c."Produkt_ID " LEFT OUTER JOIN
CRMKonto@dbl_ge tgc1 d ON b."Konto_ID" = d."Konto_ID" LEFT OUTER JOIN
calcKontoOBSdt@ dbl_getgc1 e ON b."Konto_ID" = e."Konto_ID" LEFT OUTER
JOIN
calcKonto@dbl_g etgc1 f ON b."Konto_ID" = f."Konto_ID"
WHERE (b."SlettetKont o" = 0) AND (d."MarkertForS letting" = 0 OR
d."MarkertForSl etting" IS NULL);
This insert Satement worked fine,but when I inserted from the view
already created in SQLSERVER as
:-
INSERT INTO ACCOUNT_TEST11( .....)
SELECT .............
FROM Account_anila_t est@dbl_getgc1;
This gave a following error:-
"WEB_30_SUM ", "WEB_360_COUNT" , "WEB_360_SU M", "WEB_90_COU NT",
"WEB_90_SUM "
*
ERROR at line 48:
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Transparent gateway for MSSQL]
ORA-02063: preceding 2 lines from DBL_GETGC1
Elapsed: 00:01:01.04
after this I set The paramater "HS_FDS_TRACE_L EVEL=ON" in INIt file of
tg4msql Folder then in the
trace File of tg4msql folder following error comes:-
(0)
(0) [Microsoft][ODBC SQL Server Driver]Timeout expired (SQL State:
S1T00; SQL
(0) Code: 0)
(0)
If any one has Faced the similar kind of problem and Can help me,Please
let me Know where I am
doing Wrong and How this error can be ractified.
Waiting For Reply ASAP.
Regards
Lovkesh