Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
 

Go Back   XSL - XML - RSS Forums > Programming and XML > Sybase Powerbuilder and XML

Tags:



Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 05-26-2008, 12:53 PM
zakkar
 
Posts: n/a

Default ImportString Fails when inserting XML



Hi ,

I have created in PB 11 a web service which contains a simple method.
It takes as an argument a string and with that string which is
formatted as an XML I am creating a datastore. The datastore has
already the dataobject assigned etc. etc...

The xml I am passing is the following

<?xml version='1.0' encoding='UTF-8' ?> <root> <Row Recordid='1'>
<CompanyID>DemoDash</CompanyID> <Vessel>Demo Opt</Vessel> <Port>New
York</Port> <ETA_Date>5/15/2008</ETA_Date> <ETA_Time>1000</ETA_Time>
<ETD_Date>5/17/2008</ETD_Date> <HSFO_Qty>500</HSFO_Qty> <LSFO_Qty>0</
LSFO_Qty> <MDO_Qty>0</MDO_Qty> <MGO_Qty>55</MGO_Qty> <IterationID>117</
IterationID> <UserName>Test User</UserName> <Notes>This is Test for
Integration. New York - IFO 380 cst - 500 mt</Notes> </Row> </root>

In PB code I am having a simple line of code

lds_datastore.ImportString(XML! , <the xml string>)

The strange thing is that for the localhost it is working very well
but when I am uploading to the server which it is supposed to be I'm
getting all the time "No rows or startrow value supplied is greater
than the number of rows in the string"

Why it is working for localhost and it is not working for my
webserver. The webservice is correct. I can call other
methods ,retrieve data etc.

Any ideas ?

I thought that perhaps I'm missing some dlls from the GAC. But I have
deployed everything. The webservice is running. For the localhost and
my local machine I have PB 11 installed. Also I have installed VS
2005. I haven't installed PB and VS studio .NET for the webserver.
Should I need to check if 'm missing any dlls from the webserver ???

Thank you


Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 05-26-2008, 12:53 PM
Bruce Armstrong [TeamSybase]
 
Posts: n/a

Default Re: ImportString Fails when inserting XML


PB uses a number of xerces runtime files to handle the XML import.
Have you deployed those with the app?

On Thu, 22 May 2008 05:04:59 -0700 (PDT), zakkar <zakkar@gmail.com>
wrote:

>Hi ,
>
>I have created in PB 11 a web service which contains a simple method.
>It takes as an argument a string and with that string which is
>formatted as an XML I am creating a datastore. The datastore has
>already the dataobject assigned etc. etc...
>
>The xml I am passing is the following
>
><?xml version='1.0' encoding='UTF-8' ?> <root> <Row Recordid='1'>
><CompanyID>DemoDash</CompanyID> <Vessel>Demo Opt</Vessel> <Port>New
>York</Port> <ETA_Date>5/15/2008</ETA_Date> <ETA_Time>1000</ETA_Time>
><ETD_Date>5/17/2008</ETD_Date> <HSFO_Qty>500</HSFO_Qty> <LSFO_Qty>0</
>LSFO_Qty> <MDO_Qty>0</MDO_Qty> <MGO_Qty>55</MGO_Qty> <IterationID>117</
>IterationID> <UserName>Test User</UserName> <Notes>This is Test for
>Integration. New York - IFO 380 cst - 500 mt</Notes> </Row> </root>
>
>In PB code I am having a simple line of code
>
>lds_datastore.ImportString(XML! , <the xml string>)
>
>The strange thing is that for the localhost it is working very well
>but when I am uploading to the server which it is supposed to be I'm
>getting all the time "No rows or startrow value supplied is greater
>than the number of rows in the string"
>
>Why it is working for localhost and it is not working for my
>webserver. The webservice is correct. I can call other
>methods ,retrieve data etc.
>
>Any ideas ?
>
>I thought that perhaps I'm missing some dlls from the GAC. But I have
>deployed everything. The webservice is running. For the localhost and
>my local machine I have PB 11 installed. Also I have installed VS
>2005. I haven't installed PB and VS studio .NET for the webserver.
>Should I need to check if 'm missing any dlls from the webserver ???
>
>Thank you
>


Reply With Quote
  #3 (permalink)  
Old 05-26-2008, 12:53 PM
zakkar
 
Posts: n/a

Default Re: ImportString Fails when inserting XML

On May 22, 4:36 pm, "Bruce Armstrong [TeamSybase]"
<NOCANSPAM_bruce.armstr...@teamsybase.com> wrote:
> PB uses a number of xerces runtime files to handle the XML import.
> Have you deployed those with the app?
>
> On Thu, 22 May 2008 05:04:59 -0700 (PDT), zakkar <zak...@gmail.com>
> wrote:
>
> >Hi ,

>
> >I have created in PB 11 a web service which contains a simple method.
> >It takes as an argument a string and with that string which is
> >formatted as an XML I am creating a datastore. The datastore has
> >already the dataobject assigned etc. etc...

>
> >The xml I am passing is the following

>
> ><?xml version='1.0' encoding='UTF-8' ?> <root> <Row Recordid='1'>
> ><CompanyID>DemoDash</CompanyID> <Vessel>Demo Opt</Vessel> <Port>New
> >York</Port> <ETA_Date>5/15/2008</ETA_Date> <ETA_Time>1000</ETA_Time>
> ><ETD_Date>5/17/2008</ETD_Date> <HSFO_Qty>500</HSFO_Qty> <LSFO_Qty>0</
> >LSFO_Qty> <MDO_Qty>0</MDO_Qty> <MGO_Qty>55</MGO_Qty> <IterationID>117</
> >IterationID> <UserName>Test User</UserName> <Notes>This is Test for
> >Integration. New York - IFO 380 cst - 500 mt</Notes> </Row> </root>

>
> >In PB code I am having a simple line of code

>
> >lds_datastore.ImportString(XML! , <the xml string>)

>
> >The strange thing is that for the localhost it is working very well
> >but when I am uploading to the server which it is supposed to be I'm
> >getting all the time "No rows or startrow value supplied is greater
> >than the number of rows in the string"

>
> >Why it is working for localhost and it is not working for my
> >webserver. The webservice is correct. I can call other
> >methods ,retrieve data etc.

>
> >Any ideas ?

>
> >I thought that perhaps I'm missing some dlls from the GAC. But I have
> >deployed everything. The webservice is running. For the localhost and
> >my local machine I have PB 11 installed. Also I have installed VS
> >2005. I haven't installed PB and VS studio .NET for the webserver.
> >Should I need to check if 'm missing any dlls from the webserver ???

>
> >Thank you


PBXerces110.dll , xerces-c_2_1_0.dll , xerces-c_2_6.dll , xerces-
depdom_2_6.dll are in the path. Am I missing something ?
Should I need to add them to the GAC ?

Thank you
Reply With Quote
  #4 (permalink)  
Old 05-26-2008, 12:53 PM
Bruce Armstrong [TeamSybase]
 
Posts: n/a

Default Re: ImportString Fails when inserting XML

You can't install them in the GAC, they're not strongly named assemblies.
They're not even managed assemblies.

Where did you deploy them to?

"zakkar" <zakkar@gmail.com> wrote in message
news:47061047-1a2a-45e0-aaf7-788e378d376c@m36g2000hse.googlegroups.com...
> On May 22, 4:36 pm, "Bruce Armstrong [TeamSybase]"
> <NOCANSPAM_bruce.armstr...@teamsybase.com> wrote:
>> PB uses a number of xerces runtime files to handle the XML import.
>> Have you deployed those with the app?
>>
>> On Thu, 22 May 2008 05:04:59 -0700 (PDT), zakkar <zak...@gmail.com>
>> wrote:
>>
>> >Hi ,

>>
>> >I have created in PB 11 a web service which contains a simple method.
>> >It takes as an argument a string and with that string which is
>> >formatted as an XML I am creating a datastore. The datastore has
>> >already the dataobject assigned etc. etc...

>>
>> >The xml I am passing is the following

>>
>> ><?xml version='1.0' encoding='UTF-8' ?> <root> <Row Recordid='1'>
>> ><CompanyID>DemoDash</CompanyID> <Vessel>Demo Opt</Vessel> <Port>New
>> >York</Port> <ETA_Date>5/15/2008</ETA_Date> <ETA_Time>1000</ETA_Time>
>> ><ETD_Date>5/17/2008</ETD_Date> <HSFO_Qty>500</HSFO_Qty> <LSFO_Qty>0</
>> >LSFO_Qty> <MDO_Qty>0</MDO_Qty> <MGO_Qty>55</MGO_Qty> <IterationID>117</
>> >IterationID> <UserName>Test User</UserName> <Notes>This is Test for
>> >Integration. New York - IFO 380 cst - 500 mt</Notes> </Row> </root>

>>
>> >In PB code I am having a simple line of code

>>
>> >lds_datastore.ImportString(XML! , <the xml string>)

>>
>> >The strange thing is that for the localhost it is working very well
>> >but when I am uploading to the server which it is supposed to be I'm
>> >getting all the time "No rows or startrow value supplied is greater
>> >than the number of rows in the string"

>>
>> >Why it is working for localhost and it is not working for my
>> >webserver. The webservice is correct. I can call other
>> >methods ,retrieve data etc.

>>
>> >Any ideas ?

>>
>> >I thought that perhaps I'm missing some dlls from the GAC. But I have
>> >deployed everything. The webservice is running. For the localhost and
>> >my local machine I have PB 11 installed. Also I have installed VS
>> >2005. I haven't installed PB and VS studio .NET for the webserver.
>> >Should I need to check if 'm missing any dlls from the webserver ???

>>
>> >Thank you

>
> PBXerces110.dll , xerces-c_2_1_0.dll , xerces-c_2_6.dll , xerces-
> depdom_2_6.dll are in the path. Am I missing something ?
> Should I need to add them to the GAC ?
>
> Thank you



Reply With Quote
  #5 (permalink)  
Old 05-26-2008, 12:53 PM
zakkar
 
Posts: n/a

Default Re: ImportString Fails when inserting XML

On May 22, 6:50 pm, "Bruce Armstrong [TeamSybase]"
<NOCANSPAM_bruce.armstr...@teamsybase.com> wrote:
> You can't install them in the GAC, they're not strongly named assemblies.
> They're not even managed assemblies.
>
> Where did you deploy them to?
>
> "zakkar" <zak...@gmail.com> wrote in message
>
> news:47061047-1a2a-45e0-aaf7-788e378d376c@m36g2000hse.googlegroups.com...
>
> > On May 22, 4:36 pm, "Bruce Armstrong [TeamSybase]"
> > <NOCANSPAM_bruce.armstr...@teamsybase.com> wrote:
> >> PB uses a number of xerces runtime files to handle the XML import.
> >> Have you deployed those with the app?

>
> >> On Thu, 22 May 2008 05:04:59 -0700 (PDT), zakkar <zak...@gmail.com>
> >> wrote:

>
> >> >Hi ,

>
> >> >I have created in PB 11 a web service which contains a simple method.
> >> >It takes as an argument a string and with that string which is
> >> >formatted as an XML I am creating a datastore. The datastore has
> >> >already the dataobject assigned etc. etc...

>
> >> >The xml I am passing is the following

>
> >> ><?xml version='1.0' encoding='UTF-8' ?> <root> <Row Recordid='1'>
> >> ><CompanyID>DemoDash</CompanyID> <Vessel>Demo Opt</Vessel> <Port>New
> >> >York</Port> <ETA_Date>5/15/2008</ETA_Date> <ETA_Time>1000</ETA_Time>
> >> ><ETD_Date>5/17/2008</ETD_Date> <HSFO_Qty>500</HSFO_Qty> <LSFO_Qty>0</
> >> >LSFO_Qty> <MDO_Qty>0</MDO_Qty> <MGO_Qty>55</MGO_Qty> <IterationID>117</
> >> >IterationID> <UserName>Test User</UserName> <Notes>This is Test for
> >> >Integration. New York - IFO 380 cst - 500 mt</Notes> </Row> </root>

>
> >> >In PB code I am having a simple line of code

>
> >> >lds_datastore.ImportString(XML! , <the xml string>)

>
> >> >The strange thing is that for the localhost it is working very well
> >> >but when I am uploading to the server which it is supposed to be I'm
> >> >getting all the time "No rows or startrow value supplied is greater
> >> >than the number of rows in the string"

>
> >> >Why it is working for localhost and it is not working for my
> >> >webserver. The webservice is correct. I can call other
> >> >methods ,retrieve data etc.

>
> >> >Any ideas ?

>
> >> >I thought that perhaps I'm missing some dlls from the GAC. But I have
> >> >deployed everything. The webservice is running. For the localhost and
> >> >my local machine I have PB 11 installed. Also I have installed VS
> >> >2005. I haven't installed PB and VS studio .NET for the webserver.
> >> >Should I need to check if 'm missing any dlls from the webserver ???

>
> >> >Thank you

>
> > PBXerces110.dll , xerces-c_2_1_0.dll , xerces-c_2_6.dll , xerces-
> > depdom_2_6.dll are in the path. Am I missing something ?
> > Should I need to add them to the GAC ?

>
> > Thank you


Hi ,
In a directory C:\Runtime_files. Then I have added the specific
directory in the path. The directory is in front.My webserver has
The .NET framework 2 service pack 1.
It doesn't make sense. For localhost the same code is working and not
for my server.
I even took all the files from the shared directory and put them in my
c:\Runtime_files directory. I don't know if it is much of a help but
the webserver has operating system windows server 2003.Locally i'm
having XP.
Installing also PB and .NET on the server is a different approach but
not a good one.
Should I remove the directory and put eveything in the C:\windows ?

Reply With Quote
  #6 (permalink)  
Old 05-26-2008, 12:53 PM
zakkar
 
Posts: n/a

Default Re: ImportString Fails when inserting XML

On May 23, 9:28 am, zakkar <zak...@gmail.com> wrote:
> On May 22, 6:50 pm, "Bruce Armstrong [TeamSybase]"
>
>
>
> <NOCANSPAM_bruce.armstr...@teamsybase.com> wrote:
> > You can't install them in the GAC, they're not strongly named assemblies.
> > They're not even managed assemblies.

>
> > Where did you deploy them to?

>
> > "zakkar" <zak...@gmail.com> wrote in message

>
> >news:47061047-1a2a-45e0-aaf7-788e378d376c@m36g2000hse.googlegroups.com...

>
> > > On May 22, 4:36 pm, "Bruce Armstrong [TeamSybase]"
> > > <NOCANSPAM_bruce.armstr...@teamsybase.com> wrote:
> > >> PB uses a number of xerces runtime files to handle the XML import.
> > >> Have you deployed those with the app?

>
> > >> On Thu, 22 May 2008 05:04:59 -0700 (PDT), zakkar <zak...@gmail.com>
> > >> wrote:

>
> > >> >Hi ,

>
> > >> >I have created in PB 11 a web service which contains a simple method.
> > >> >It takes as an argument a string and with that string which is
> > >> >formatted as an XML I am creating a datastore. The datastore has
> > >> >already the dataobject assigned etc. etc...

>
> > >> >The xml I am passing is the following

>
> > >> ><?xml version='1.0' encoding='UTF-8' ?> <root> <Row Recordid='1'>
> > >> ><CompanyID>DemoDash</CompanyID> <Vessel>Demo Opt</Vessel> <Port>New
> > >> >York</Port> <ETA_Date>5/15/2008</ETA_Date> <ETA_Time>1000</ETA_Time>
> > >> ><ETD_Date>5/17/2008</ETD_Date> <HSFO_Qty>500</HSFO_Qty> <LSFO_Qty>0</
> > >> >LSFO_Qty> <MDO_Qty>0</MDO_Qty> <MGO_Qty>55</MGO_Qty> <IterationID>117</
> > >> >IterationID> <UserName>Test User</UserName> <Notes>This is Test for
> > >> >Integration. New York - IFO 380 cst - 500 mt</Notes> </Row> </root>

>
> > >> >In PB code I am having a simple line of code

>
> > >> >lds_datastore.ImportString(XML! , <the xml string>)

>
> > >> >The strange thing is that for the localhost it is working very well
> > >> >but when I am uploading to the server which it is supposed to be I'm
> > >> >getting all the time "No rows or startrow value supplied is greater
> > >> >than the number of rows in the string"

>
> > >> >Why it is working for localhost and it is not working for my
> > >> >webserver. The webservice is correct. I can call other
> > >> >methods ,retrieve data etc.

>
> > >> >Any ideas ?

>
> > >> >I thought that perhaps I'm missing some dlls from the GAC. But I have
> > >> >deployed everything. The webservice is running. For the localhost and
> > >> >my local machine I have PB 11 installed. Also I have installed VS
> > >> >2005. I haven't installed PB and VS studio .NET for the webserver.
> > >> >Should I need to check if 'm missing any dlls from the webserver ???

>
> > >> >Thank you

>
> > > PBXerces110.dll , xerces-c_2_1_0.dll , xerces-c_2_6.dll , xerces-
> > > depdom_2_6.dll are in the path. Am I missing something ?
> > > Should I need to add them to the GAC ?

>
> > > Thank you

>
> Hi ,
> In a directory C:\Runtime_files. Then I have added the specific
> directory in the path. The directory is in front.My webserver has
> The .NET framework 2 service pack 1.
> It doesn't make sense. For localhost the same code is working and not
> for my server.
> I even took all the files from the shared directory and put them in my
> c:\Runtime_files directory. I don't know if it is much of a help but
> the webserver has operating system windows server 2003.Locally i'm
> having XP.
> Installing also PB and .NET on the server is a different approach but
> not a good one.
> Should I remove the directory and put eveything in the C:\windows ?


What about security ? Is it possible that security permissions prevent
the datastore to execute the importstring command ?I haven't apply any
permissions to the webserver.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



Contact Us -|- XSL - XML - RSS Forums -|- Archive -|- Top -|-Rules/Disclaimer-|-Help/Support -|-Advertise
© Camley Interactive (camley.info) 2008 - all logos and images are copywrite their respective owners.
Proud member of the Camley Interactive Network
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.
All times are GMT. The time now is 11:46 AM.
Style Developed by Epic Designz