Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Help - Failed during SetDWObject

3 posts in PowerSite specific Last posting was on 2001-08-07 12:08:22.0Z
lichn Posted on 2001-08-06 20:13:48.0Z
Newsgroups: sybase.public.powersite
From: lichn
Date: Mon, 6 Aug 2001 16:13:48 -0400
Subject: Help - Failed during SetDWObject
Lines: 233
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <382_F1F59726B0C9DB4E006F20BA85256AA0.006F20CC85256AA0@webforums>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.powersite:126
Article PK: 862560

I have exhausted all my knowledge. Help is greatly appreciated. I am
running
Window NT 4.0 SVP 6,
EAStudio 3.5 c5 Release
PowerBuilder 7.0.3 build 10047 , Jaguar CTS 3.5 build 35045, PowerDynamo
3.5.0.35002GA, PowerSite 7.1 build 300, Adaptive Server Anywhere 6.02 build
2188
Everything was working fine, until I lost the C Drive. I have rebuilt
everything. My application is on C and Sybase software is on D:.
In PowerBuilder have rebuild my .pbls and redeployed them to Jaguar. I have
generated and compiled my stubs for my packages. Deployed my PowerSite
project out to PowerDynamo. I know that the connection between PowerDynamo
and Jaguar is working properly, I can see the access to the NVO for the
login process(n_login). However when I go to a page that retrieves data
through a DataWindow, I get the Failed during SetDWObject and in the Jaguar
svr.log I see Exiting SetDWObject() = -1. I've checked to system
enviorments to insure that I had the proper ClassPaths and Path and that
there were no duplicates. Checked my Jaguar Connection Cache Name and it
is
IIOSCache_ODBC. The name and path of the DataWindow Object is correct.


Code from my PowerSite page to the setdwobject
<%@ LANGUAGE=JavaScript %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML lang="en_US">
<HEAD>
<META NAME=SERVERLANGUAGE CONTENT=JavaScript HTTP-EQUIV=PowerSiteData>
<TITLE></TITLE>
<META content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<META name=GENERATOR content="MSHTML 5.00.2314.1000">
<META http-equiv=REFRESH>
<LINK type="text/css" href="styles/iios.css" rel=Stylesheet>
</HEAD>
<BODY>
<H2>IIOS-HR Personnel Employees&nbsp; </H2>
<DIV id=div1></DIV>
<!--SCRIPT
import( site.GetRootDocument().location + "ServerUtils.pss");

function GetParam(envparam)
{
if (exists(document.value[envparam]))
{
return document.value[envparam]
}
}

function TestError(returnCode, action)
{
if(returnCode < 0)
{
psDocument.WriteLn("Failed during: " + action + "<BR>" +
dwData.getlasterrorstring() + "<BR>");
}
}

// Check to make sure the sessino is still valid
iios_checkSession()

// Initialize variables from session information
server_name = psSession.GetValue("server_name");
dw_location = psSession.GetValue("dw_location");
jag_login = psSession.GetValue("jag_login");
jag_password = psSession.GetValue("jag_password");
db_connect = psSession.GetValue("db_connect_cache");
dbms = psSession.GetValue("dbms");

// Instantiate the HTML Datawindow
dwData = java.CreateComponent("iios_web/HTMLGenerator", "iiop://" +
server_name, jag_login, jag_password, "iios_web/HTMLGenerator")

if (dwData == null)
{
psDocument.WriteLn("Error: " + site.GetErrorInfo() + "<BR>");
exit;
}
psDocument.WriteLn("<BR>" + dwData_action + "<BR>" + dwData_context);

// Set the Datawindow Object
returnCode = dwData.setdwobject(dw_location,"d_employee_list");
TestError(returnCode, "SetDWObject");

My Jaguar svr.log
Aug 03 14:49:05 2001:
Sybase Enterprise Application Server3.5(Developer Edition).This version of
Enterprise Application Server(TM) 3.5 is licensed solely for development
purposes.
Any other use of software, including but not limited to production use or
use on a webserver is strictly prohibited.Deployment licenses may be
obtained from Sybase, Inc. for a fee.
Aug 03 14:49:05 2001: Jaguar CTS - Component Transaction Server/Version 3.5
(Build 35045)/P/PC Intel/Windows NT 4.0/OPT/Dec 18 2000 16:29:02

Confidential property of Sybase, Inc.
(c) Copyright Sybase Inc. 1987,1999
All rights reserved.

Use, duplication, or disclosure by the United States Government
is subject to restrictions as set forth in FAR subparagraphs
52.227-19 (a)-(d) for civilian agency contracts and DFARS 252.227-7013
(c)(1)(ii) for Department of Defense contracts. Sybase reserves all
unpublished rights under the copyright laws of the United States.
Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608 USA.
Aug 03 14:49:05 2001:
2 Phase Commit Option Licensed
Aug 03 14:49:05 2001: CLUSTERING Option Licensed
Aug 03 14:49:05 2001:
High Availibilty Option Licensed
Aug 03 14:49:05 2001:
Application Integrator for CICS Option Licensed
Aug 03 14:49:09 2001: Listener # 1: Jaguar_tds: Active: yes Protocol:
'TDS': 'localhost',7878 Security Profile: '*NONE*'
Aug 03 14:49:09 2001: Listener # 2: Jaguar_OpenServer: Active: yes
Protocol: 'TDS': 'localhost',7979 Security Profile: '*NONE*'
Aug 03 14:49:09 2001: Listener # 3: Jaguar_http: Active: yes Protocol:
'HTTP': 'localhost',8080 Security Profile: '*NONE*'
Aug 03 14:49:09 2001: Listener # 4: Jaguar_https1: Active: yes Protocol:
'HTTPS': 'localhost',8081 Security Profile: 'sybpks_intl'
Subject DN: CN = Sample1, O = Some Organization, L = Some Locality, ST =
Some State, C = US
Aug 03 14:49:09 2001: Listener # 5: Jaguar_https2: Active: yes Protocol:
'HTTPS': 'localhost',8082 Security Profile: 'sybpks_intl_mutual_auth'
Subject DN: CN = Sample2, O = Some Organization, L = Some Locality, ST =
Some State, C = US
Aug 03 14:49:09 2001: Listener # 6: Jaguar_iiop: Active: yes Protocol:
'IIOP': 'localhost',9000 Security Profile: '*NONE*'
Aug 03 14:49:09 2001: Listener # 7: Jaguar_iiops1: Active: yes Protocol:
'IIOPS': 'localhost',9001 Security Profile: 'sybpks_intl'
Subject DN: CN = Sample1, O = Some Organization, L = Some Locality, ST =
Some State, C = US
Aug 03 14:49:09 2001: Listener # 8: Jaguar_iiops2: Active: yes Protocol:
'IIOPS': 'localhost',9002 Security Profile: 'sybpks_intl_mutual_auth'
Subject DN: CN = Sample2, O = Some Organization, L = Some Locality, ST =
Some State, C = US
Aug 03 14:49:09 2001: Listener # 9: Jaguar_iiop1: Active: yes Protocol:
'IIOP': 'SDCLEELICHN',9000 Security Profile: '*NONE*'
Aug 03 14:49:09 2001: Starting Jaguar CTS 3.5
Aug 03 14:49:09 2001: Server's native codeset is utf8
Warning: Failed to initialize SSLServiceProvider: reason: 23
Aug 03 14:49:09 2001: Library: 'libjjdk11x.dll' for component type 'java'
Aug 03 14:49:09 2001: Java JIT Compiler disabled
Aug 03 14:49:09 2001: Java component debugging disabled
Aug 03 14:49:10 2001: Java virtual machine initialized (version 10001)
Aug 03 14:49:10 2001: Repository: D:\Sybase\Jaguar CTS 3.5\Repository
Aug 03 14:49:11 2001: Host IP: 127.0.0.1
Aug 03 14:49:11 2001: NameServiceURL: iiop://0:0
Aug 03 14:49:11 2001: Starting Services...
Aug 03 14:49:12 2001: Started: Jaguar/Repository
Aug 03 14:49:12 2001: Started: Jaguar/GarbageCollector
Aug 03 14:49:12 2001: Started: Jaguar/JCM
Aug 03 14:49:13 2001: Starting Jaguar Naming Services...
Aug 03 14:49:13 2001: Started: CosNaming/NamingContext
Aug 03 14:49:13 2001: Started: CtsServlet/ServletService
Aug 03 14:49:13 2001: Running: services...
Aug 03 14:49:13 2001: Running: CosNaming/NamingContext
Aug 03 14:49:13 2001: Running: Jaguar/GarbageCollector
Aug 03 14:49:13 2001: Running: CtsServlet/ServletService
Aug 03 14:49:17 2001: Stopped: CosNaming/NamingContext
Aug 03 14:49:47 2001: Authentication timeout period is 3600 seconds.
Note: authentication timeout can be disabled.
Aug 03 14:49:47 2001: Authentication lockout period is 600 seconds.
Note: authentication lockout can be disabled.
Aug 03 14:49:50 2001: CONSTRUCTOR n_login
Aug 03 14:49:50 2001: ACTIVATE n_login
Aug 03 14:49:50 2001: AuthUserLogin n_login
Aug 03 14:49:50 2001: AuthConnect n_login
Aug 03 14:49:50 2001: Warning: DLL name is different, using previous name
Aug 03 14:49:57 2001: HTMLDW: Remote DataWindow Component logging enabled
Aug 03 14:49:57 2001: HTMLDW: Default Library List = 'D:\sybase\Jaguar CTS
3.5\Repository\Component\iios_web\HTMLGenerator\C3\iios_HTMLGenerator.pbd'
Aug 03 14:49:57 2001: HTMLDW: Loaded component properties:
Aug 03 14:49:57 2001: HTMLDW: sourceFileName = ''
Aug 03 14:49:57 2001: HTMLDW: dwObjectName = ''
Aug 03 14:49:57 2001: HTMLDW: HTMLObjectName = ''
Aug 03 14:49:57 2001: HTMLDW: modifyString = ''
Aug 03 14:49:57 2001: HTMLDW: fixed = 'no'
Aug 03 14:49:57 2001: HTMLDW: serverSideState = 'no'
Aug 03 14:49:57 2001: HTMLDW: trans.dbms = ''
Aug 03 14:49:57 2001: HTMLDW: trans.dbparm = ''
Aug 03 14:49:57 2001: HTMLDW: trans.lock = ''
Aug 03 14:49:57 2001: HTMLDW: trans.logid = ''
Aug 03 14:49:57 2001: HTMLDW: trans.logpass = ''
Aug 03 14:49:57 2001: HTMLDW: trans.database = ''
Aug 03 14:49:57 2001: HTMLDW: trans.servername = ''
Aug 03 14:49:57 2001: HTMLDW: serverServiceClasses = ''
Aug 03 14:49:57 2001: HTMLDW: Activate()
Aug 03 14:49:57 2001: HTMLDW: Entering
SetDWObject('C:/IIOS_WEB/Source/Web/iios_personnel_server.pbl','d_employee_list')
Aug 03 14:49:57 2001: HTMLDW: Doing PBL/PBD
Aug 03 14:49:57 2001: HTMLDW: Exiting SetDWObject() = -1
Aug 03 14:49:57 2001: HTMLDW: EnableCommit()
Aug 03 14:49:57 2001: HTMLDW: GetLastErrorString() = ''
Aug 03 14:49:57 2001: HTMLDW: EnableCommit()
Aug 03 14:49:58 2001: HTMLDW: Entering
SetSelfLink('employees_list.htm','lname='""'|ssn='""'')
Aug 03 14:49:58 2001: HTMLDW: Exiting SetSelfLink() = ''
Aug 03 14:49:58 2001: HTMLDW: EnableCommit()
Aug 03 14:49:58 2001: HTMLDW: Entering SetHTMLObjectName('dwData')
Aug 03 14:49:58 2001: HTMLDW: Exiting SetHTMLObjectName() = ''
Aug 03 14:49:58 2001: HTMLDW: EnableCommit()
Aug 03 14:49:58 2001: HTMLDW: Entering SetBrowser('Mozilla/4.0 (compatible;
MSIE 5.5; Windows NT 4.0)')
Aug 03 14:49:58 2001: HTMLDW: Exiting SetBrowser() = ''
Aug 03 14:49:58 2001: HTMLDW: EnableCommit()
Aug 03 14:49:58 2001: HTMLDW: Entering SetTrans()
Aug 03 14:49:58 2001: HTMLDW: Exiting SetTrans() = 1
Aug 03 14:49:58 2001: HTMLDW: EnableCommit()
Aug 03 14:49:58 2001: HTMLDW: Entering
SetColumnLink('ssn','employees_detail.htm','rowid='rowid + ""'|ssn='ssn +
""'')
Aug 03 14:49:58 2001: HTMLDW: Exiting SetColumnLink() = ''
Aug 03 14:49:58 2001: HTMLDW: EnableCommit()
Aug 03 14:49:58 2001: HTMLDW: Entering
SetColumnLink('per_employee_name','employees_detail.htm','rowid='rowid +
""'|ssn='ssn + ""'')
Aug 03 14:49:58 2001: HTMLDW: Exiting SetColumnLink() = ''
Aug 03 14:49:58 2001: HTMLDW: EnableCommit()
Aug 03 14:49:59 2001: HTMLDW: Entering RetrieveEx('%
%
%

')
Aug 03 14:49:59 2001: HTMLDW: Exiting RetrieveEx() = 0
Aug 03 14:49:59 2001: HTMLDW: EnableCommit()
Aug 03 14:49:59 2001: HTMLDW: Entering Generate()
Aug 03 14:49:59 2001: HTMLDW: Exiting Generate(), length = 0
Aug 03 14:49:59 2001: HTMLDW: SetComplete()
Aug 03 14:49:59 2001: HTMLDW: Entering Deactivate()
Aug 03 14:49:59 2001: HTMLDW: resetting state
Aug 03 14:49:59 2001: HTMLDW: Exiting Deactivate()


John Strano[TeamSybase] Posted on 2001-08-06 20:40:22.0Z
Newsgroups: sybase.public.powersite
From: John Strano[TeamSybase] <nichtspam_jstrano@csi.com>
Subject: Re: Help - Failed during SetDWObject
Date: Mon, 6 Aug 2001 16:40:22 -0400
X-Newsreader: MicroPlanet Gravity v2.30
Lines: 61
NNTP-Posting-Host: c05-164.012.popsite.net 64.24.48.164
Message-ID: <382_MPG.15d8cac5add0cb239896b5@forums.sybase.com>
References: <382_F1F59726B0C9DB4E006F20BA85256AA0.006F20CC85256AA0@webforums>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powersite:124
Article PK: 840493

C:/IIOS_WEB/Source/Web/iios_personnel_server.pbl exists and
you can open and preview d_employee_list in the dw painter?

================================================================
John Strano
[TeamSybase]

In article <F1F59726B0C9DB4E006F20BA85256AA0.006F20CC85256AA0@webforums>,
lichn says...

> I have exhausted all my knowledge. Help is greatly appreciated. I am
> running
> Window NT 4.0 SVP 6,
> EAStudio 3.5 c5 Release
> PowerBuilder 7.0.3 build 10047 , Jaguar CTS 3.5 build 35045, PowerDynamo
> 3.5.0.35002GA, PowerSite 7.1 build 300, Adaptive Server Anywhere 6.02 build
> 2188
> Everything was working fine, until I lost the C Drive. I have rebuilt
> everything. My application is on C and Sybase software is on D:.
> In PowerBuilder have rebuild my .pbls and redeployed them to Jaguar. I have
> generated and compiled my stubs for my packages. Deployed my PowerSite
> project out to PowerDynamo. I know that the connection between PowerDynamo
> and Jaguar is working properly, I can see the access to the NVO for the
> login process(n_login). However when I go to a page that retrieves data
> through a DataWindow, I get the Failed during SetDWObject and in the Jaguar
> svr.log I see Exiting SetDWObject() = -1. I've checked to system
> enviorments to insure that I had the proper ClassPaths and Path and that
> there were no duplicates. Checked my Jaguar Connection Cache Name and it
> is
> IIOSCache_ODBC. The name and path of the DataWindow Object is correct.
>
>
> Code from my PowerSite page to the setdwobject
> <%@ LANGUAGE=JavaScript %>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML lang="en_US">
> <HEAD>
> <META NAME=SERVERLANGUAGE CONTENT=JavaScript HTTP-EQUIV=PowerSiteData>
> <TITLE></TITLE>
> <META content="text/html; charset=windows-1252"
> http-equiv="Content-Type">
> <META name=GENERATOR content="MSHTML 5.00.2314.1000">
> <META http-equiv=REFRESH>
> <LINK type="text/css" href="styles/iios.css" rel=Stylesheet>
> </HEAD>
> <BODY>
> <H2>IIOS-HR Personnel Employees&nbsp; </H2>
> <DIV id=div1></DIV>
> <!--SCRIPT
> import( site.GetRootDocument().location + "ServerUtils.pss");
>
> function GetParam(envparam)
> {
> if (exists(document.value[envparam]))
> {
> return document.value[envparam]
> }
> }
>
> function TestError(returnCode, action)


lichn Posted on 2001-08-07 12:08:22.0Z
Newsgroups: sybase.public.powersite
From: lichn
Date: Tue, 7 Aug 2001 08:08:22 -0400
Subject: Re: Help - Failed during SetDWObject
Lines: 4
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <382_138D6A81BFBA08DC0042AF2485256AA1.00767A5B85256AA0@webforums>
References: <382_F1F59726B0C9DB4E006F20BA85256AA0.006F20CC85256AA0@webforums> <382_MPG.15d8cac5add0cb239896b5@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.powersite:122
Article PK: 862558

Yes, C:\IIOS_WEB\Source\Web\iios_personnel_server.pbl and d_employees_list
exists. I can preview the data in PowerBuilder. I can't get any
DataWindows to display on my web pages, but I can execute the NVOs. I will
recheck the path for my pbl.