SQL Problem after Hardware Change ?l

------_=_NextPart_001_01C7CF92.478225D2
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_002_01C7CF92.478225D2"


------_=_NextPart_002_01C7CF92.478225D2
X-EC0D2A8E-5CB7-4969-9C36-46D859D137BE-PartID: 3EE5574A-64B4-4F09-BB81-FDA588CEF48E
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello Everybody !
=20
My application(MaxDB no SAP) connects via odbc to a SAP System with =
maxdb database(7.5.00.44) and fires the following command:
=20
DECLARE PUFFER CURSOR FOR WITH RECURSIVE TMPPUFFER=20
(LEVEL,stlnummer,stlbezeich,stlnr,postp,posnr,matnr,matbezeich,menge,mein=
s,erskz,stlnrid) =20
 AS (SELECT 1, ma2.matnr as stlnummer,stltextd.maktg as =
stlbezeich,stpo.stlnr,
 stpo.postp,stpo.posnr,stpo.idnrk as matnr,matextd.maktg as =
matbezeich,stpo.menge,stpo.meins,stpo.erskz, ma1.stlnr as stlnrid=20
 from stpo=20
 join mast ma2 on stpo.stlnr =3D ma2.stlnr and ma2.mandt =3D '900'=20
 join makt matextd on stpo.idnrk =3D matextd.matnr and matextd.mandt =3D =
'900' and matextd.spras =3D 'D'
 join makt stltextd on ma2.matnr =3D stltextd.matnr and stltextd.mandt =
=3D '900' and stltextd.spras =3D 'D'
 left join mast ma1 on stpo.idnrk =3D ma1.matnr and ma1.mandt =3D '900'=20
 where stpo.mandt =3D '900' and stpo.stlty =3D 'M' and stpo.stlnr =3D =
'00216214'
 UNION ALL SELECT TMPPUFFER.LEVEL + 1, ma2.matnr as =
stlnummer,stltextd.maktg as stlbezeich, stpo.stlnr,
 stpo.postp,stpo.posnr,stpo.idnrk as matnr,matextd.maktg as =
matbezeich,stpo.menge,stpo.meins,stpo.erskz,
 ma1.stlnr as stlnrid=20
 FROM TMPPUFFER,stpo=20
 join mast ma2 on stpo.stlnr =3D ma2.stlnr and ma2.mandt =3D '900'=20
 join makt matextd on stpo.idnrk =3D matextd.matnr and matextd.mandt =3D =
'900'  and matextd.spras =3D 'D'=20
 join makt stltextd on ma2.matnr =3D stltextd.matnr and stltextd.mandt =
=3D '900' and stltextd.spras =3D 'D'
 left join mast ma1 on stpo.idnrk =3D ma1.matnr and ma1.mandt =3D '900'=20
 where stpo.mandt =3D '900' and stpo.stlty =3D 'M' and stpo.stlnr =3D =
TMPPUFFER.stlnrid)=20
 SELECT TMPPUFFER.* FROM TMPPUFFER=20
 order by level,stlnr,posnr
=20
=20
For more than 6 month everything works as expected.
I use the result cursor to update spezial tables in my system.
=20
Now the SAP System was migrated from HP-UX on a PA-Risc Server to HP-UX =
on a Integrity Server. (Same MaxDB Version).
SAP is running quick and fine, but my command stops with the following =
error

 1526
Connectivity-Fehler: [SAP AG][SQLOD32 DLL][MaxDB] Base table or view =
already exists;-6000 POS(1) Duplicate table name
[SAP AG][SQLOD32 DLL][MaxDB] Base table or view already exists;-6000 =
POS(1) Duplicate table name
S0001
-6000
=20
????????????????
Any help welcomed
=20

Best regards
________________________________________

<file://%25logonserver%25/netlogon/eMailSignature/pd-logo.bmp> =
<file://%25logonserver%25/netlogon/eMailSignature/pd-logo.bmp> Albert =
Beermann =20
Abteilungsleiter=20
Informationsverarbeitung=20


   Piepenbrock Service GmbH + Co. KG=20
  Hannoversche Str. 91-95=20
  49084 Osnabr=FCck=20
  Tel: +49 (0) 541/5841-868=20
  Fax: +49 (0) 541/5841-869=20
  Mobil: +49 (0) 177/9400868=20
  E-Mail:[email protected]=20
  www.piepenbrock.de=20
________________________________________

Kommanditgesellschaft Sitz Osnabr=FCck HRA 6519 AG Osnabr=FCck phG: =
Piepenbrock Service Verwaltungs- und Beteiligungsgesellschaft mbH HRB =
19436 AG Osnabr=FCck Gesch=E4ftsf=FChrer: Arnulf Piepenbrock, Olaf =
Piepenbrock Paul Richter St-Nr.FA:66/204/26100 Osnabr=FCck-Stadt =
Ust.-ID-Nr.: DE 166472497 Sicherheitsnr Bauabzugssteuer: 236620320479=20


Diese eMail enth=E4lt vertrauliche und/oder rechtlich gesch=FCtzte =
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese =
eMail irrt=FCmlich erhalten haben, informieren Sie bitte sofort den =
Absender und vernichten diese eMail. Das unerlaubte Kopieren sowie die =
unbefugte Weitergabe dieser eMail ist nicht gestattet.

=20

=20

------_=_NextPart_002_01C7CF92.478225D2
X-EC0D2A8E-5CB7-4969-9C36-46D859D137BE-PartID: 56927BFF-A546-42E6-B128-1FED1445EAAF
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Nachricht</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.3132" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D934002414-26072007>Hello =
Everybody=20
!</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D934002414-26072007></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D934002414-26072007>My =
application(MaxDB=20
no SAP)&nbsp;connects via odbc to a SAP System with maxdb =
database(7.5.00.44)=20
and fires the following command:</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D934002414-26072007></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>DECLARE PUFFER CURSOR FOR WITH =
RECURSIVE TMPPUFFER=20
<BR>(LEVEL,stlnummer,stlbezeich,stlnr,postp,posnr,matnr,matbezeich,menge,=
meins,erskz,stlnrid)&nbsp;=20
<BR>&nbsp;AS (SELECT 1, ma2.matnr as stlnummer,stltextd.maktg as=20
stlbezeich,stpo.stlnr,<BR>&nbsp;stpo.postp,stpo.posnr,stpo.idnrk as=20
matnr,matextd.maktg as matbezeich,stpo.menge,stpo.meins,stpo.erskz, =
ma1.stlnr as=20
stlnrid <BR>&nbsp;from stpo <BR>&nbsp;join mast ma2 on stpo.stlnr =3D =
ma2.stlnr=20
and ma2.mandt =3D '900' <BR>&nbsp;join makt matextd on stpo.idnrk =3D =
matextd.matnr=20
and matextd.mandt =3D '900' and matextd.spras =3D 'D'<BR>&nbsp;join makt =
stltextd on=20
ma2.matnr =3D stltextd.matnr and stltextd.mandt =3D '900' and =
stltextd.spras =3D=20
'D'<BR>&nbsp;left join mast ma1 on stpo.idnrk =3D ma1.matnr and =
ma1.mandt =3D '900'=20
<BR>&nbsp;where stpo.mandt =3D '900' and stpo.stlty =3D 'M' and =
stpo.stlnr=20
=3D&nbsp;<SPAN =
class=3D934002414-26072007>'00216214'</SPAN><BR>&nbsp;UNION ALL=20
SELECT TMPPUFFER.LEVEL + 1, ma2.matnr as stlnummer,stltextd.maktg as =
stlbezeich,=20
stpo.stlnr,<BR>&nbsp;stpo.postp,stpo.posnr,stpo.idnrk as =
matnr,matextd.maktg as=20
matbezeich,stpo.menge,stpo.meins,stpo.erskz,<BR>&nbsp;ma1.stlnr as =
stlnrid=20
<BR>&nbsp;FROM TMPPUFFER,stpo <BR>&nbsp;join mast ma2 on stpo.stlnr =3D =
ma2.stlnr=20
and ma2.mandt =3D '900' <BR>&nbsp;join makt matextd on stpo.idnrk =3D =
matextd.matnr=20
and matextd.mandt =3D '900'&nbsp; and matextd.spras =3D 'D' =
<BR>&nbsp;join makt=20
stltextd on ma2.matnr =3D stltextd.matnr and stltextd.mandt =3D '900' =
and=20
stltextd.spras =3D 'D'<BR>&nbsp;left join mast ma1 on stpo.idnrk =3D =
ma1.matnr and=20
ma1.mandt =3D '900' <BR>&nbsp;where stpo.mandt =3D '900' and stpo.stlty =
=3D 'M' and=20
stpo.stlnr =3D TMPPUFFER.stlnrid) <BR>&nbsp;SELECT TMPPUFFER.* FROM =
TMPPUFFER=20
<BR>&nbsp;order by level,stlnr,posnr<BR>&nbsp;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D934002414-26072007>For =
more than 6=20
month everything works as expected.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D934002414-26072007>I use =
the result=20
cursor to update spezial tables in my system.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D934002414-26072007></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D934002414-26072007>Now =
the SAP System=20
was migrated from HP-UX on a PA-Risc Server to HP-UX on a Integrity =
Server.=20
(Same MaxDB Version).</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D934002414-26072007>SAP is =
running quick=20
and fine, but my command stops with the following=20
error</SPAN></FONT></DIV><FONT>
<DIV><BR><FONT face=3DArial size=3D2>&nbsp;1526<BR>Connectivity-Fehler: =
[SAP=20
AG][SQLOD32 DLL][MaxDB] Base table or view already exists;-6000 POS(1) =
Duplicate=20
table name<BR>[SAP AG][SQLOD32 DLL][MaxDB] Base table or view already=20
exists;-6000 POS(1) Duplicate table name<BR>S0001<BR>-6000</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D934002414-26072007>????????????????</SPAN></FONT></DIV>
<DIV></FONT><SPAN class=3D934002414-26072007><FONT face=3DArial =
size=3D2>Any help=20
welcomed</FONT></SPAN></DIV>
<DIV>&nbsp;</DIV>
<DIV>
<P><SPAN style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: =
Arial"><SPAN class=3D934002414-26072007></SPAN></SPAN><SPAN =
style=3D"FONT-SIZE: 10pt; COLOR: black">B<SPAN =
class=3D934002414-26072007>est=20
regards</SPAN><BR>________________________________________</SPAN><SPAN =
style=3D"COLOR: black"><?xml:namespace prefix =3D o ns =3D=20
"urn:schemas-microsoft-com:office:office" /></SPAN></P>
<P></P>
<P style=3D"MARGIN: 0cm 0cm 0pt"><SPAN style=3D"FONT-SIZE: 10pt; COLOR: =
black; FONT-FAMILY: Arial"><A></A><SPAN style=3D"mso-spacerun: =
yes"><FONT color=3D#000000><SPAN style=3D"FONT-SIZE: 10pt; COLOR: black; =
FONT-FAMILY: Arial"><A></A><SPAN style=3D"mso-spacerun: yes"><FONT =
color=3D#000000><STRONG>Albert Beermann=20
&nbsp;<BR></STRONG>Abteilungsleiter <BR>Informationsverarbeitung=20
<BR><BR></FONT></SPAN></SPAN></FONT><BR>&nbsp;<IMG =
src=3D"cid:934002414@26072007-182E">&nbsp;Piepenbrock Service GmbH + Co. =
KG=20
<BR>&nbsp; Hannoversche Str. 91-95 <BR></SPAN></SPAN><FONT =
color=3D#000000><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial">&nbsp; 49084 Osnabr=FCck <BR>&nbsp;=20
Tel: +49 (0) 541/5841-868 <BR>&nbsp; Fa<FONT color=3D#000000>x: +49 (0)=20
541/5841-869 <BR>&nbsp; Mobil: +49 (0) 177/9400868 <BR>&nbsp;=20
E-Mail:[email protected] <BR></FONT></SPAN></FONT><SPAN =
style=3D"FONT-SIZE: 10pt"><FONT face=3DArial>&nbsp; www.piepenbrock.de=20
</FONT><BR>________________________________________<BR><BR><FONT =
face=3DArial color=3D#000000 size=3D1>Kommanditgesellschaft Sitz =
Osnabr=FCck HRA 6519 AG Osnabr=FCck=20
phG: Piepenbrock Service Verwaltungs- und Beteiligungsgesellschaft mbH =
HRB 19436=20
AG Osnabr=FCck Gesch=E4ftsf=FChrer: Arnulf Piepenbrock, Olaf Piepenbrock =
Paul Richter=20
St-Nr.FA:66/204/26100 Osnabr=FCck-Stadt Ust.-ID-Nr.: DE 166472497 =
Sicherheitsnr=20
Bauabzugssteuer: 236620320479 <BR></FONT></SPAN></P></DIV>
<P class=3DMsoNormal><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><FONT color=3D#000000><FONT size=3D1>Diese eMail enth=E4lt =
vertrauliche und/oder rechtlich=20
gesch=FCtzte Informationen. Wenn Sie nicht der richtige Adressat sind =
oder diese=20
eMail irrt=FCmlich erhalten haben, informieren Sie bitte sofort den =
Absender und=20
vernichten diese eMail. Das unerlaubte Kopieren sowie die unbefugte =
Weitergabe=20
dieser eMail ist nicht gestattet.</FONT></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"></SPAN>&nbsp;</P><!--eMS4.8.5.D26M.7Y.2007-->
<DIV>&nbsp;</DIV></BODY></HTML>

------_=_NextPart_002_01C7CF92.478225D2--

------_=_NextPart_001_01C7CF92.478225D2--