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.

Winform App Disappearing - PB 12.1 Build 7107

7 posts in General Discussion Last posting was on 2013-03-15 19:39:16.0Z
Paul Murray Posted on 2013-03-13 11:51:43.0Z
From: "Paul Murray" <pemurray@interrasys.com>
Newsgroups: sybase.public.powerbuilder.general
Subject: Winform App Disappearing - PB 12.1 Build 7107
Lines: 248
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <5140684f$1@forums-1-dub>
Date: 13 Mar 2013 03:51:43 -0800
X-Trace: forums-1-dub 1363175503 172.20.134.152 (13 Mar 2013 03:51:43 -0800)
X-Original-Trace: 13 Mar 2013 03:51:43 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:249903
Article PK: 1308316

Greetings All,

I have a small Winform application running on a Windows Server 2003 Hyper-V
machine. I have both PB Runtimes installed for version 12.1 and 12.5.

It works fine for about 14 hours and then it simply disappears. There is no
dialog box with any type of error. I can't find any type of error in the
event logs except an occasional system error related to WS32Time as:

"The time provider NtpClient is configured to acquire time from one or more
time sources, however none of the sources are currently accessible. No
attempt to contact a source will be made for 15 minutes. NtpClient has no
source of accurate time."

There is no PBTrace.log in the application directory.

What the application does:

1) I have code in a timer object that fires every 60 seconds.
2) Two datastores are created, data is moved and the datastores are
destroyed.
3) A function is called which calls a webservice.
4) Depending on certain results one of three different email functions are
called that send out emails using some .net code.

If someone can kindly suggest how to trap the error or where to find an
error, I would really appreciate it.

I have gone through all of the code that has any datastores or .net objects
and made sure that I am destroying them after use.

Thank you,

Paul

Here is the primary code that fires in the timer object:

***START TIMER CODE***
timer(0, w_main)

running = running + 1
sequence = sequence + 1

st_1.text = string(datetime(today(),now()))

long i
long rows
string car_no
string geo_car_no
string confo
string geofence_confo
datetime req_date_time

datastore trips
trips = create datastore
trips.dataobject = 'dw_monitor_eligible_trips'
trips.settransobject(sqlca)
rows = trips.retrieve()

if rows > 0 then

for i = 1 to rows

confo = trim(trips.getitemstring(i, "operator_confirmation_no"))
req_date_time = trips.getitemdatetime(i, "operator_req_date_time")
car_no = trim(trips.getitemstring(i, "operator_car_no"))
if car_no = "2189" then
goto done
end if
geofence_confo = trim(trips.getitemstring(i,
"ft_v_geofence_confirmation_no"))
geo_car_no = trim(trips.getitemstring(i, "ft_v_geofence_car_no"))

if isnull(geofence_confo) then

trips.setitem(i, "ft_v_geofence_confirmation_no", confo)
trips.setitem(i, "ft_v_geofence_car_no", car_no)
trips.setitem(i, "ft_v_geofence_record_insert_dt",
datetime(today(),now()))
trips.setitem(i, "ft_v_geofence_req_date_time", req_date_time)

trips.setitemstatus(i,0,Primary!, NewModified!) //insert the row
//dw_1.setitemstatus(i,0,Primary!, DataModified!) //update the row
//dw_1.setitemstatus(i,0,Primary!, NotModified!) //don't do anything

elseif car_no <> geo_car_no then

trips.setitem(i, "ft_v_geofence_car_no", car_no)
trips.setitem(i, "ft_v_geofence_record_change_dt",
datetime(today(),now()))
trips.setitemstatus(i,0,Primary!, DataModified!) //update the row

end if

trips.update()
commit;

done:

next

datetime rightnow
rightnow = datetime(today(),now())
datetime datetime_5_minutes_behind
datetime_5_minutes_behind =
uf_calc_new_date_time_from_horizon_minus(rightnow, -5)

long gps_rows
datetime geofence_dt
double latitude
double longitude
string status
string dr_no
datetime ld_date_time

datastore gps
gps = create datastore
gps.dataobject = 'dw_gps'
gps.settransobject(sqlca)

for i = 1 to rows

confo = trim(trips.getitemstring(i, "operator_confirmation_no"))
car_no = trim(trips.getitemstring(i, "operator_car_no"))
if car_no = "2189" then
goto done2
end if
status = trim(trips.getitemstring(i, "operator_status_flag"))
dr_no = trim(trips.getitemstring(i, "operator_dr_no"))
ld_date_time = trips.getitemdatetime(i, "operator_ld_date_time")

geofence_dt = trips.getitemdatetime(i,
"ft_v_geofence_in_geofence_date_time")

if isnull(geofence_dt) then //this wont be null after VR rule runs and
sends the alert

gps_rows = gps.retrieve(datetime_5_minutes_behind, integer(car_no))

if gps_rows = 1 then

latitude = gps.getitemnumber(1, "latitude")
longitude = gps.getitemnumber(1, "longitude")
trips.setitem(i, "ft_v_geofence_car_pos_lat", latitude)
trips.setitem(i, "ft_v_geofence_car_pos_long", longitude)
trips.setitem(i, "ft_v_geofence_record_change_dt",
datetime(today(),now()))
trips.setitemstatus(i,0,Primary!, DataModified!) //update the row
else
if sequence = 8 then
uf_send_email(confo, car_no, status,ld_date_time)
end if

INSERT INTO ft_v_gps_data_not_found
( confirmation_no,
gps_check_date_time,
trip_status,
car_no,
dr_id )
VALUES ( :confo,
:rightnow,
:status,
:car_no,
:dr_no ) ;

commit;

end if

end if

trips.update()
commit;

done2:

next

end if

destroy trips
destroy gps

if sequence = 4 or sequence = 8 then
uf_fire_vr_geofence_ws()
end if

if sequence = 8 then
sequence = 0
end if

if running = 240 then
uf_send_email_alive()
running = 0
end if

timer(15, w_main)
***END TIMER CODE***

***START UF_FIRE_GEOFENCE_WS CODE***
long rc
SoapConnection conn
p_vaa_geo_fenceservice proxy
p_vrresponse response
p_vrrequest request
string result

conn = create SoapConnection
rc = conn.CreateInstance( proxy, "p_vaa_geo_fenceservice")

try

request = create p_vrrequest
request.input = create p_masterinput
request.target = create p_target
request.configuration = create p_configuration

request.input.password = "PB"
request.target.version = "0.0.1"
//request.configuration.sessionstatistics.level = 1 //uncommenting this
causes an exception

response = proxy.vaa_geo_fence_webservicewrapper_master(request)

IF NOT isValid(response) THEN
result = "Did not get a response object from the webservice"
return result
END IF

IF NOT isValid(response.output) THEN
result = "Response Object does not contain an Output Object"
return result
END IF

result = string(response.output.response)

catch ( SoapException e )

result = e.text

end try

destroy conn

return result
***END UF_FIRE_GEOFENCE_WS CODE***


Chris Pollach Posted on 2013-03-13 12:33:53.0Z
From: Chris Pollach <cpollach@travel-net.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20130307 Thunderbird/17.0.4
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.general
Subject: Re: Winform App Disappearing - PB 12.1 Build 7107
References: <5140684f$1@forums-1-dub>
In-Reply-To: <5140684f$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <51407231@forums-1-dub>
Date: 13 Mar 2013 04:33:53 -0800
X-Trace: forums-1-dub 1363178033 172.20.134.152 (13 Mar 2013 04:33:53 -0800)
X-Original-Trace: 13 Mar 2013 04:33:53 -0800, vip152.sybase.com
Lines: 273
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:249907
Article PK: 1308319

Hi Paul;

1) Do all DC's and DS's have code in the DBError, ItemError, Error and
WebService events to capture & log any DBMS or Web Service errors?

2) Does the TransAction Object contain code to trap & log any DBMS errors.

3) Does your Application Object trap & log the SystemError event?

--

Regards ... Chris
President: OSUG / STD Inc.
Vice President: ISUG-TECH
Blog: http://chrispollach.blogspot.com
SourceForge: http://sourceforge.net/projects/stdfndclass
PBDJ: http://chrispollach.sys-con.com
TKD: http://www.syeoh.com

On 3/13/2013 7:51 AM, Paul Murray wrote:
> Greetings All,
>
> I have a small Winform application running on a Windows Server 2003 Hyper-V
> machine. I have both PB Runtimes installed for version 12.1 and 12.5.
>
> It works fine for about 14 hours and then it simply disappears. There is no
> dialog box with any type of error. I can't find any type of error in the
> event logs except an occasional system error related to WS32Time as:
>
> "The time provider NtpClient is configured to acquire time from one or more
> time sources, however none of the sources are currently accessible. No
> attempt to contact a source will be made for 15 minutes. NtpClient has no
> source of accurate time."
>
> There is no PBTrace.log in the application directory.
>
> What the application does:
>
> 1) I have code in a timer object that fires every 60 seconds.
> 2) Two datastores are created, data is moved and the datastores are
> destroyed.
> 3) A function is called which calls a webservice.
> 4) Depending on certain results one of three different email functions are
> called that send out emails using some .net code.
>
> If someone can kindly suggest how to trap the error or where to find an
> error, I would really appreciate it.
>
> I have gone through all of the code that has any datastores or .net objects
> and made sure that I am destroying them after use.
>
> Thank you,
>
> Paul
>
> Here is the primary code that fires in the timer object:
>
> ***START TIMER CODE***
> timer(0, w_main)
>
> running = running + 1
> sequence = sequence + 1
>
> st_1.text = string(datetime(today(),now()))
>
> long i
> long rows
> string car_no
> string geo_car_no
> string confo
> string geofence_confo
> datetime req_date_time
>
> datastore trips
> trips = create datastore
> trips.dataobject = 'dw_monitor_eligible_trips'
> trips.settransobject(sqlca)
> rows = trips.retrieve()
>
> if rows > 0 then
>
> for i = 1 to rows
>
> confo = trim(trips.getitemstring(i, "operator_confirmation_no"))
> req_date_time = trips.getitemdatetime(i, "operator_req_date_time")
> car_no = trim(trips.getitemstring(i, "operator_car_no"))
> if car_no = "2189" then
> goto done
> end if
> geofence_confo = trim(trips.getitemstring(i,
> "ft_v_geofence_confirmation_no"))
> geo_car_no = trim(trips.getitemstring(i, "ft_v_geofence_car_no"))
>
> if isnull(geofence_confo) then
>
> trips.setitem(i, "ft_v_geofence_confirmation_no", confo)
> trips.setitem(i, "ft_v_geofence_car_no", car_no)
> trips.setitem(i, "ft_v_geofence_record_insert_dt",
> datetime(today(),now()))
> trips.setitem(i, "ft_v_geofence_req_date_time", req_date_time)
>
> trips.setitemstatus(i,0,Primary!, NewModified!) //insert the row
> //dw_1.setitemstatus(i,0,Primary!, DataModified!) //update the row
> //dw_1.setitemstatus(i,0,Primary!, NotModified!) //don't do anything
>
> elseif car_no <> geo_car_no then
>
> trips.setitem(i, "ft_v_geofence_car_no", car_no)
> trips.setitem(i, "ft_v_geofence_record_change_dt",
> datetime(today(),now()))
> trips.setitemstatus(i,0,Primary!, DataModified!) //update the row
>
> end if
>
> trips.update()
> commit;
>
> done:
>
> next
>
> datetime rightnow
> rightnow = datetime(today(),now())
> datetime datetime_5_minutes_behind
> datetime_5_minutes_behind =
> uf_calc_new_date_time_from_horizon_minus(rightnow, -5)
>
> long gps_rows
> datetime geofence_dt
> double latitude
> double longitude
> string status
> string dr_no
> datetime ld_date_time
>
> datastore gps
> gps = create datastore
> gps.dataobject = 'dw_gps'
> gps.settransobject(sqlca)
>
> for i = 1 to rows
>
> confo = trim(trips.getitemstring(i, "operator_confirmation_no"))
> car_no = trim(trips.getitemstring(i, "operator_car_no"))
> if car_no = "2189" then
> goto done2
> end if
> status = trim(trips.getitemstring(i, "operator_status_flag"))
> dr_no = trim(trips.getitemstring(i, "operator_dr_no"))
> ld_date_time = trips.getitemdatetime(i, "operator_ld_date_time")
>
> geofence_dt = trips.getitemdatetime(i,
> "ft_v_geofence_in_geofence_date_time")
>
> if isnull(geofence_dt) then //this wont be null after VR rule runs and
> sends the alert
>
> gps_rows = gps.retrieve(datetime_5_minutes_behind, integer(car_no))
>
> if gps_rows = 1 then
>
> latitude = gps.getitemnumber(1, "latitude")
> longitude = gps.getitemnumber(1, "longitude")
> trips.setitem(i, "ft_v_geofence_car_pos_lat", latitude)
> trips.setitem(i, "ft_v_geofence_car_pos_long", longitude)
> trips.setitem(i, "ft_v_geofence_record_change_dt",
> datetime(today(),now()))
> trips.setitemstatus(i,0,Primary!, DataModified!) //update the row
> else
> if sequence = 8 then
> uf_send_email(confo, car_no, status,ld_date_time)
> end if
>
> INSERT INTO ft_v_gps_data_not_found
> ( confirmation_no,
> gps_check_date_time,
> trip_status,
> car_no,
> dr_id )
> VALUES ( :confo,
> :rightnow,
> :status,
> :car_no,
> :dr_no ) ;
>
> commit;
>
> end if
>
> end if
>
> trips.update()
> commit;
>
> done2:
>
> next
>
> end if
>
> destroy trips
> destroy gps
>
> if sequence = 4 or sequence = 8 then
> uf_fire_vr_geofence_ws()
> end if
>
> if sequence = 8 then
> sequence = 0
> end if
>
> if running = 240 then
> uf_send_email_alive()
> running = 0
> end if
>
> timer(15, w_main)
> ***END TIMER CODE***
>
> ***START UF_FIRE_GEOFENCE_WS CODE***
> long rc
> SoapConnection conn
> p_vaa_geo_fenceservice proxy
> p_vrresponse response
> p_vrrequest request
> string result
>
> conn = create SoapConnection
> rc = conn.CreateInstance( proxy, "p_vaa_geo_fenceservice")
>
> try
>
> request = create p_vrrequest
> request.input = create p_masterinput
> request.target = create p_target
> request.configuration = create p_configuration
>
> request.input.password = "PB"
> request.target.version = "0.0.1"
> //request.configuration.sessionstatistics.level = 1 //uncommenting this
> causes an exception
>
> response = proxy.vaa_geo_fence_webservicewrapper_master(request)
>
> IF NOT isValid(response) THEN
> result = "Did not get a response object from the webservice"
> return result
> END IF
>
> IF NOT isValid(response.output) THEN
> result = "Response Object does not contain an Output Object"
> return result
> END IF
>
> result = string(response.output.response)
>
> catch ( SoapException e )
>
> result = e.text
>
> end try
>
> destroy conn
>
> return result
> ***END UF_FIRE_GEOFENCE_WS CODE***
>
>


Paul Murray Posted on 2013-03-13 13:05:52.0Z
From: "Paul Murray" <pemurray@interrasys.com>
Newsgroups: sybase.public.powerbuilder.general
References: <5140684f$1@forums-1-dub> <51407231@forums-1-dub>
Subject: Re: Winform App Disappearing - PB 12.1 Build 7107
Lines: 294
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <514079b0@forums-1-dub>
Date: 13 Mar 2013 05:05:52 -0800
X-Trace: forums-1-dub 1363179952 172.20.134.152 (13 Mar 2013 05:05:52 -0800)
X-Original-Trace: 13 Mar 2013 05:05:52 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:249908
Article PK: 1308322

Thanks, Chris.

In a word...No.

I guess I will have to dig into that and write some sort of logging utility.
Ugh. :(

Thanks again.

Paul

"Chris Pollach" <cpollach@travel-net.com> wrote in message
news:51407231@forums-1-dub...
>
> Hi Paul;
>
> 1) Do all DC's and DS's have code in the DBError, ItemError, Error and
> WebService events to capture & log any DBMS or Web Service errors?
>
> 2) Does the TransAction Object contain code to trap & log any DBMS errors.
>
> 3) Does your Application Object trap & log the SystemError event?
>
> --
>
> Regards ... Chris
> President: OSUG / STD Inc.
> Vice President: ISUG-TECH
> Blog: http://chrispollach.blogspot.com
> SourceForge: http://sourceforge.net/projects/stdfndclass
> PBDJ: http://chrispollach.sys-con.com
> TKD: http://www.syeoh.com
>
>
>
>
> On 3/13/2013 7:51 AM, Paul Murray wrote:
>> Greetings All,
>>
>> I have a small Winform application running on a Windows Server 2003
>> Hyper-V
>> machine. I have both PB Runtimes installed for version 12.1 and 12.5.
>>
>> It works fine for about 14 hours and then it simply disappears. There is
>> no
>> dialog box with any type of error. I can't find any type of error in the
>> event logs except an occasional system error related to WS32Time as:
>>
>> "The time provider NtpClient is configured to acquire time from one or
>> more
>> time sources, however none of the sources are currently accessible. No
>> attempt to contact a source will be made for 15 minutes. NtpClient has no
>> source of accurate time."
>>
>> There is no PBTrace.log in the application directory.
>>
>> What the application does:
>>
>> 1) I have code in a timer object that fires every 60 seconds.
>> 2) Two datastores are created, data is moved and the datastores are
>> destroyed.
>> 3) A function is called which calls a webservice.
>> 4) Depending on certain results one of three different email functions
>> are
>> called that send out emails using some .net code.
>>
>> If someone can kindly suggest how to trap the error or where to find an
>> error, I would really appreciate it.
>>
>> I have gone through all of the code that has any datastores or .net
>> objects
>> and made sure that I am destroying them after use.
>>
>> Thank you,
>>
>> Paul
>>
>> Here is the primary code that fires in the timer object:
>>
>> ***START TIMER CODE***
>> timer(0, w_main)
>>
>> running = running + 1
>> sequence = sequence + 1
>>
>> st_1.text = string(datetime(today(),now()))
>>
>> long i
>> long rows
>> string car_no
>> string geo_car_no
>> string confo
>> string geofence_confo
>> datetime req_date_time
>>
>> datastore trips
>> trips = create datastore
>> trips.dataobject = 'dw_monitor_eligible_trips'
>> trips.settransobject(sqlca)
>> rows = trips.retrieve()
>>
>> if rows > 0 then
>>
>> for i = 1 to rows
>>
>> confo = trim(trips.getitemstring(i, "operator_confirmation_no"))
>> req_date_time = trips.getitemdatetime(i, "operator_req_date_time")
>> car_no = trim(trips.getitemstring(i, "operator_car_no"))
>> if car_no = "2189" then
>> goto done
>> end if
>> geofence_confo = trim(trips.getitemstring(i,
>> "ft_v_geofence_confirmation_no"))
>> geo_car_no = trim(trips.getitemstring(i, "ft_v_geofence_car_no"))
>>
>> if isnull(geofence_confo) then
>>
>> trips.setitem(i, "ft_v_geofence_confirmation_no", confo)
>> trips.setitem(i, "ft_v_geofence_car_no", car_no)
>> trips.setitem(i, "ft_v_geofence_record_insert_dt",
>> datetime(today(),now()))
>> trips.setitem(i, "ft_v_geofence_req_date_time", req_date_time)
>>
>> trips.setitemstatus(i,0,Primary!, NewModified!) //insert the row
>> //dw_1.setitemstatus(i,0,Primary!, DataModified!) //update the row
>> //dw_1.setitemstatus(i,0,Primary!, NotModified!) //don't do anything
>>
>> elseif car_no <> geo_car_no then
>>
>> trips.setitem(i, "ft_v_geofence_car_no", car_no)
>> trips.setitem(i, "ft_v_geofence_record_change_dt",
>> datetime(today(),now()))
>> trips.setitemstatus(i,0,Primary!, DataModified!) //update the row
>>
>> end if
>>
>> trips.update()
>> commit;
>>
>> done:
>>
>> next
>>
>> datetime rightnow
>> rightnow = datetime(today(),now())
>> datetime datetime_5_minutes_behind
>> datetime_5_minutes_behind =
>> uf_calc_new_date_time_from_horizon_minus(rightnow, -5)
>>
>> long gps_rows
>> datetime geofence_dt
>> double latitude
>> double longitude
>> string status
>> string dr_no
>> datetime ld_date_time
>>
>> datastore gps
>> gps = create datastore
>> gps.dataobject = 'dw_gps'
>> gps.settransobject(sqlca)
>>
>> for i = 1 to rows
>>
>> confo = trim(trips.getitemstring(i, "operator_confirmation_no"))
>> car_no = trim(trips.getitemstring(i, "operator_car_no"))
>> if car_no = "2189" then
>> goto done2
>> end if
>> status = trim(trips.getitemstring(i, "operator_status_flag"))
>> dr_no = trim(trips.getitemstring(i, "operator_dr_no"))
>> ld_date_time = trips.getitemdatetime(i, "operator_ld_date_time")
>>
>> geofence_dt = trips.getitemdatetime(i,
>> "ft_v_geofence_in_geofence_date_time")
>>
>> if isnull(geofence_dt) then //this wont be null after VR rule runs and
>> sends the alert
>>
>> gps_rows = gps.retrieve(datetime_5_minutes_behind, integer(car_no))
>>
>> if gps_rows = 1 then
>>
>> latitude = gps.getitemnumber(1, "latitude")
>> longitude = gps.getitemnumber(1, "longitude")
>> trips.setitem(i, "ft_v_geofence_car_pos_lat", latitude)
>> trips.setitem(i, "ft_v_geofence_car_pos_long", longitude)
>> trips.setitem(i, "ft_v_geofence_record_change_dt",
>> datetime(today(),now()))
>> trips.setitemstatus(i,0,Primary!, DataModified!) //update the row
>> else
>> if sequence = 8 then
>> uf_send_email(confo, car_no, status,ld_date_time)
>> end if
>>
>> INSERT INTO ft_v_gps_data_not_found
>> ( confirmation_no,
>> gps_check_date_time,
>> trip_status,
>> car_no,
>> dr_id )
>> VALUES ( :confo,
>> :rightnow,
>> :status,
>> :car_no,
>> :dr_no ) ;
>>
>> commit;
>>
>> end if
>>
>> end if
>>
>> trips.update()
>> commit;
>>
>> done2:
>>
>> next
>>
>> end if
>>
>> destroy trips
>> destroy gps
>>
>> if sequence = 4 or sequence = 8 then
>> uf_fire_vr_geofence_ws()
>> end if
>>
>> if sequence = 8 then
>> sequence = 0
>> end if
>>
>> if running = 240 then
>> uf_send_email_alive()
>> running = 0
>> end if
>>
>> timer(15, w_main)
>> ***END TIMER CODE***
>>
>> ***START UF_FIRE_GEOFENCE_WS CODE***
>> long rc
>> SoapConnection conn
>> p_vaa_geo_fenceservice proxy
>> p_vrresponse response
>> p_vrrequest request
>> string result
>>
>> conn = create SoapConnection
>> rc = conn.CreateInstance( proxy, "p_vaa_geo_fenceservice")
>>
>> try
>>
>> request = create p_vrrequest
>> request.input = create p_masterinput
>> request.target = create p_target
>> request.configuration = create p_configuration
>>
>> request.input.password = "PB"
>> request.target.version = "0.0.1"
>> //request.configuration.sessionstatistics.level = 1 //uncommenting this
>> causes an exception
>>
>> response = proxy.vaa_geo_fence_webservicewrapper_master(request)
>>
>> IF NOT isValid(response) THEN
>> result = "Did not get a response object from the webservice"
>> return result
>> END IF
>>
>> IF NOT isValid(response.output) THEN
>> result = "Response Object does not contain an Output Object"
>> return result
>> END IF
>>
>> result = string(response.output.response)
>>
>> catch ( SoapException e )
>>
>> result = e.text
>>
>> end try
>>
>> destroy conn
>>
>> return result
>> ***END UF_FIRE_GEOFENCE_WS CODE***
>>
>>
>


DirtPour Posted on 2013-03-14 15:12:02.0Z
From: DirtPour <myemail@yahoo.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:18.0) Gecko/20100101 Firefox/18.0 SeaMonkey/2.15.2
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.general
Subject: Re: Winform App Disappearing - PB 12.1 Build 7107
References: <5140684f$1@forums-1-dub> <51407231@forums-1-dub> <514079b0@forums-1-dub>
In-Reply-To: <514079b0@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <5141e8c2@forums-1-dub>
Date: 14 Mar 2013 07:12:02 -0800
X-Trace: forums-1-dub 1363273922 172.20.134.152 (14 Mar 2013 07:12:02 -0800)
X-Original-Trace: 14 Mar 2013 07:12:02 -0800, vip152.sybase.com
Lines: 304
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:249942
Article PK: 1308369

It sounds like an App pool issue similar to what we once had.

We solved it by putting the Web form on it's own App pool.

Paul Murray wrote:
> Thanks, Chris.
>
> In a word...No.
>
> I guess I will have to dig into that and write some sort of logging utility.
> Ugh. :(
>
> Thanks again.
>
> Paul
>
>
> "Chris Pollach" <cpollach@travel-net.com> wrote in message
> news:51407231@forums-1-dub...
>>
>> Hi Paul;
>>
>> 1) Do all DC's and DS's have code in the DBError, ItemError, Error and
>> WebService events to capture & log any DBMS or Web Service errors?
>>
>> 2) Does the TransAction Object contain code to trap & log any DBMS errors.
>>
>> 3) Does your Application Object trap & log the SystemError event?
>>
>> --
>>
>> Regards ... Chris
>> President: OSUG / STD Inc.
>> Vice President: ISUG-TECH
>> Blog: http://chrispollach.blogspot.com
>> SourceForge: http://sourceforge.net/projects/stdfndclass
>> PBDJ: http://chrispollach.sys-con.com
>> TKD: http://www.syeoh.com
>>
>>
>>
>>
>> On 3/13/2013 7:51 AM, Paul Murray wrote:
>>> Greetings All,
>>>
>>> I have a small Winform application running on a Windows Server 2003
>>> Hyper-V
>>> machine. I have both PB Runtimes installed for version 12.1 and 12.5.
>>>
>>> It works fine for about 14 hours and then it simply disappears. There is
>>> no
>>> dialog box with any type of error. I can't find any type of error in the
>>> event logs except an occasional system error related to WS32Time as:
>>>
>>> "The time provider NtpClient is configured to acquire time from one or
>>> more
>>> time sources, however none of the sources are currently accessible. No
>>> attempt to contact a source will be made for 15 minutes. NtpClient has no
>>> source of accurate time."
>>>
>>> There is no PBTrace.log in the application directory.
>>>
>>> What the application does:
>>>
>>> 1) I have code in a timer object that fires every 60 seconds.
>>> 2) Two datastores are created, data is moved and the datastores are
>>> destroyed.
>>> 3) A function is called which calls a webservice.
>>> 4) Depending on certain results one of three different email functions
>>> are
>>> called that send out emails using some .net code.
>>>
>>> If someone can kindly suggest how to trap the error or where to find an
>>> error, I would really appreciate it.
>>>
>>> I have gone through all of the code that has any datastores or .net
>>> objects
>>> and made sure that I am destroying them after use.
>>>
>>> Thank you,
>>>
>>> Paul
>>>
>>> Here is the primary code that fires in the timer object:
>>>
>>> ***START TIMER CODE***
>>> timer(0, w_main)
>>>
>>> running = running + 1
>>> sequence = sequence + 1
>>>
>>> st_1.text = string(datetime(today(),now()))
>>>
>>> long i
>>> long rows
>>> string car_no
>>> string geo_car_no
>>> string confo
>>> string geofence_confo
>>> datetime req_date_time
>>>
>>> datastore trips
>>> trips = create datastore
>>> trips.dataobject = 'dw_monitor_eligible_trips'
>>> trips.settransobject(sqlca)
>>> rows = trips.retrieve()
>>>
>>> if rows > 0 then
>>>
>>> for i = 1 to rows
>>>
>>> confo = trim(trips.getitemstring(i, "operator_confirmation_no"))
>>> req_date_time = trips.getitemdatetime(i, "operator_req_date_time")
>>> car_no = trim(trips.getitemstring(i, "operator_car_no"))
>>> if car_no = "2189" then
>>> goto done
>>> end if
>>> geofence_confo = trim(trips.getitemstring(i,
>>> "ft_v_geofence_confirmation_no"))
>>> geo_car_no = trim(trips.getitemstring(i, "ft_v_geofence_car_no"))
>>>
>>> if isnull(geofence_confo) then
>>>
>>> trips.setitem(i, "ft_v_geofence_confirmation_no", confo)
>>> trips.setitem(i, "ft_v_geofence_car_no", car_no)
>>> trips.setitem(i, "ft_v_geofence_record_insert_dt",
>>> datetime(today(),now()))
>>> trips.setitem(i, "ft_v_geofence_req_date_time", req_date_time)
>>>
>>> trips.setitemstatus(i,0,Primary!, NewModified!) //insert the row
>>> //dw_1.setitemstatus(i,0,Primary!, DataModified!) //update the row
>>> //dw_1.setitemstatus(i,0,Primary!, NotModified!) //don't do anything
>>>
>>> elseif car_no <> geo_car_no then
>>>
>>> trips.setitem(i, "ft_v_geofence_car_no", car_no)
>>> trips.setitem(i, "ft_v_geofence_record_change_dt",
>>> datetime(today(),now()))
>>> trips.setitemstatus(i,0,Primary!, DataModified!) //update the row
>>>
>>> end if
>>>
>>> trips.update()
>>> commit;
>>>
>>> done:
>>>
>>> next
>>>
>>> datetime rightnow
>>> rightnow = datetime(today(),now())
>>> datetime datetime_5_minutes_behind
>>> datetime_5_minutes_behind =
>>> uf_calc_new_date_time_from_horizon_minus(rightnow, -5)
>>>
>>> long gps_rows
>>> datetime geofence_dt
>>> double latitude
>>> double longitude
>>> string status
>>> string dr_no
>>> datetime ld_date_time
>>>
>>> datastore gps
>>> gps = create datastore
>>> gps.dataobject = 'dw_gps'
>>> gps.settransobject(sqlca)
>>>
>>> for i = 1 to rows
>>>
>>> confo = trim(trips.getitemstring(i, "operator_confirmation_no"))
>>> car_no = trim(trips.getitemstring(i, "operator_car_no"))
>>> if car_no = "2189" then
>>> goto done2
>>> end if
>>> status = trim(trips.getitemstring(i, "operator_status_flag"))
>>> dr_no = trim(trips.getitemstring(i, "operator_dr_no"))
>>> ld_date_time = trips.getitemdatetime(i, "operator_ld_date_time")
>>>
>>> geofence_dt = trips.getitemdatetime(i,
>>> "ft_v_geofence_in_geofence_date_time")
>>>
>>> if isnull(geofence_dt) then //this wont be null after VR rule runs and
>>> sends the alert
>>>
>>> gps_rows = gps.retrieve(datetime_5_minutes_behind, integer(car_no))
>>>
>>> if gps_rows = 1 then
>>>
>>> latitude = gps.getitemnumber(1, "latitude")
>>> longitude = gps.getitemnumber(1, "longitude")
>>> trips.setitem(i, "ft_v_geofence_car_pos_lat", latitude)
>>> trips.setitem(i, "ft_v_geofence_car_pos_long", longitude)
>>> trips.setitem(i, "ft_v_geofence_record_change_dt",
>>> datetime(today(),now()))
>>> trips.setitemstatus(i,0,Primary!, DataModified!) //update the row
>>> else
>>> if sequence = 8 then
>>> uf_send_email(confo, car_no, status,ld_date_time)
>>> end if
>>>
>>> INSERT INTO ft_v_gps_data_not_found
>>> ( confirmation_no,
>>> gps_check_date_time,
>>> trip_status,
>>> car_no,
>>> dr_id )
>>> VALUES ( :confo,
>>> :rightnow,
>>> :status,
>>> :car_no,
>>> :dr_no ) ;
>>>
>>> commit;
>>>
>>> end if
>>>
>>> end if
>>>
>>> trips.update()
>>> commit;
>>>
>>> done2:
>>>
>>> next
>>>
>>> end if
>>>
>>> destroy trips
>>> destroy gps
>>>
>>> if sequence = 4 or sequence = 8 then
>>> uf_fire_vr_geofence_ws()
>>> end if
>>>
>>> if sequence = 8 then
>>> sequence = 0
>>> end if
>>>
>>> if running = 240 then
>>> uf_send_email_alive()
>>> running = 0
>>> end if
>>>
>>> timer(15, w_main)
>>> ***END TIMER CODE***
>>>
>>> ***START UF_FIRE_GEOFENCE_WS CODE***
>>> long rc
>>> SoapConnection conn
>>> p_vaa_geo_fenceservice proxy
>>> p_vrresponse response
>>> p_vrrequest request
>>> string result
>>>
>>> conn = create SoapConnection
>>> rc = conn.CreateInstance( proxy, "p_vaa_geo_fenceservice")
>>>
>>> try
>>>
>>> request = create p_vrrequest
>>> request.input = create p_masterinput
>>> request.target = create p_target
>>> request.configuration = create p_configuration
>>>
>>> request.input.password = "PB"
>>> request.target.version = "0.0.1"
>>> //request.configuration.sessionstatistics.level = 1 //uncommenting this
>>> causes an exception
>>>
>>> response = proxy.vaa_geo_fence_webservicewrapper_master(request)
>>>
>>> IF NOT isValid(response) THEN
>>> result = "Did not get a response object from the webservice"
>>> return result
>>> END IF
>>>
>>> IF NOT isValid(response.output) THEN
>>> result = "Response Object does not contain an Output Object"
>>> return result
>>> END IF
>>>
>>> result = string(response.output.response)
>>>
>>> catch ( SoapException e )
>>>
>>> result = e.text
>>>
>>> end try
>>>
>>> destroy conn
>>>
>>> return result
>>> ***END UF_FIRE_GEOFENCE_WS CODE***
>>>
>>>
>>
>
>


Paul Murray Posted on 2013-03-14 16:34:17.0Z
From: "Paul Murray" <pemurray@interrasys.com>
Newsgroups: sybase.public.powerbuilder.general
References: <5140684f$1@forums-1-dub> <51407231@forums-1-dub> <514079b0@forums-1-dub> <5141e8c2@forums-1-dub>
Subject: Re: Winform App Disappearing - PB 12.1 Build 7107
Lines: 324
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <5141fc09@forums-1-dub>
Date: 14 Mar 2013 08:34:17 -0800
X-Trace: forums-1-dub 1363278857 172.20.134.152 (14 Mar 2013 08:34:17 -0800)
X-Original-Trace: 14 Mar 2013 08:34:17 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:249943
Article PK: 1308372

Thanks, but this is a Winform and not a webform.

The odd thing is that this is the first windows application that I have ever
created that just decides to close down without an error message. It's
annoying!!

"DirtPour" <myemail@yahoo.com> wrote in message
news:5141e8c2@forums-1-dub...
>
>
> It sounds like an App pool issue similar to what we once had.
>
> We solved it by putting the Web form on it's own App pool.
>
>
>
> Paul Murray wrote:
>> Thanks, Chris.
>>
>> In a word...No.
>>
>> I guess I will have to dig into that and write some sort of logging
>> utility.
>> Ugh. :(
>>
>> Thanks again.
>>
>> Paul
>>
>>
>> "Chris Pollach" <cpollach@travel-net.com> wrote in message
>> news:51407231@forums-1-dub...
>>>
>>> Hi Paul;
>>>
>>> 1) Do all DC's and DS's have code in the DBError, ItemError, Error and
>>> WebService events to capture & log any DBMS or Web Service errors?
>>>
>>> 2) Does the TransAction Object contain code to trap & log any DBMS
>>> errors.
>>>
>>> 3) Does your Application Object trap & log the SystemError event?
>>>
>>> --
>>>
>>> Regards ... Chris
>>> President: OSUG / STD Inc.
>>> Vice President: ISUG-TECH
>>> Blog: http://chrispollach.blogspot.com
>>> SourceForge: http://sourceforge.net/projects/stdfndclass
>>> PBDJ: http://chrispollach.sys-con.com
>>> TKD: http://www.syeoh.com
>>>
>>>
>>>
>>>
>>> On 3/13/2013 7:51 AM, Paul Murray wrote:
>>>> Greetings All,
>>>>
>>>> I have a small Winform application running on a Windows Server 2003
>>>> Hyper-V
>>>> machine. I have both PB Runtimes installed for version 12.1 and 12.5.
>>>>
>>>> It works fine for about 14 hours and then it simply disappears. There
>>>> is
>>>> no
>>>> dialog box with any type of error. I can't find any type of error in
>>>> the
>>>> event logs except an occasional system error related to WS32Time as:
>>>>
>>>> "The time provider NtpClient is configured to acquire time from one or
>>>> more
>>>> time sources, however none of the sources are currently accessible. No
>>>> attempt to contact a source will be made for 15 minutes. NtpClient has
>>>> no
>>>> source of accurate time."
>>>>
>>>> There is no PBTrace.log in the application directory.
>>>>
>>>> What the application does:
>>>>
>>>> 1) I have code in a timer object that fires every 60 seconds.
>>>> 2) Two datastores are created, data is moved and the datastores are
>>>> destroyed.
>>>> 3) A function is called which calls a webservice.
>>>> 4) Depending on certain results one of three different email functions
>>>> are
>>>> called that send out emails using some .net code.
>>>>
>>>> If someone can kindly suggest how to trap the error or where to find an
>>>> error, I would really appreciate it.
>>>>
>>>> I have gone through all of the code that has any datastores or .net
>>>> objects
>>>> and made sure that I am destroying them after use.
>>>>
>>>> Thank you,
>>>>
>>>> Paul
>>>>
>>>> Here is the primary code that fires in the timer object:
>>>>
>>>> ***START TIMER CODE***
>>>> timer(0, w_main)
>>>>
>>>> running = running + 1
>>>> sequence = sequence + 1
>>>>
>>>> st_1.text = string(datetime(today(),now()))
>>>>
>>>> long i
>>>> long rows
>>>> string car_no
>>>> string geo_car_no
>>>> string confo
>>>> string geofence_confo
>>>> datetime req_date_time
>>>>
>>>> datastore trips
>>>> trips = create datastore
>>>> trips.dataobject = 'dw_monitor_eligible_trips'
>>>> trips.settransobject(sqlca)
>>>> rows = trips.retrieve()
>>>>
>>>> if rows > 0 then
>>>>
>>>> for i = 1 to rows
>>>>
>>>> confo = trim(trips.getitemstring(i, "operator_confirmation_no"))
>>>> req_date_time = trips.getitemdatetime(i, "operator_req_date_time")
>>>> car_no = trim(trips.getitemstring(i, "operator_car_no"))
>>>> if car_no = "2189" then
>>>> goto done
>>>> end if
>>>> geofence_confo = trim(trips.getitemstring(i,
>>>> "ft_v_geofence_confirmation_no"))
>>>> geo_car_no = trim(trips.getitemstring(i, "ft_v_geofence_car_no"))
>>>>
>>>> if isnull(geofence_confo) then
>>>>
>>>> trips.setitem(i, "ft_v_geofence_confirmation_no", confo)
>>>> trips.setitem(i, "ft_v_geofence_car_no", car_no)
>>>> trips.setitem(i, "ft_v_geofence_record_insert_dt",
>>>> datetime(today(),now()))
>>>> trips.setitem(i, "ft_v_geofence_req_date_time", req_date_time)
>>>>
>>>> trips.setitemstatus(i,0,Primary!, NewModified!) //insert the row
>>>> //dw_1.setitemstatus(i,0,Primary!, DataModified!) //update the row
>>>> //dw_1.setitemstatus(i,0,Primary!, NotModified!) //don't do
>>>> anything
>>>>
>>>> elseif car_no <> geo_car_no then
>>>>
>>>> trips.setitem(i, "ft_v_geofence_car_no", car_no)
>>>> trips.setitem(i, "ft_v_geofence_record_change_dt",
>>>> datetime(today(),now()))
>>>> trips.setitemstatus(i,0,Primary!, DataModified!) //update the row
>>>>
>>>> end if
>>>>
>>>> trips.update()
>>>> commit;
>>>>
>>>> done:
>>>>
>>>> next
>>>>
>>>> datetime rightnow
>>>> rightnow = datetime(today(),now())
>>>> datetime datetime_5_minutes_behind
>>>> datetime_5_minutes_behind =
>>>> uf_calc_new_date_time_from_horizon_minus(rightnow, -5)
>>>>
>>>> long gps_rows
>>>> datetime geofence_dt
>>>> double latitude
>>>> double longitude
>>>> string status
>>>> string dr_no
>>>> datetime ld_date_time
>>>>
>>>> datastore gps
>>>> gps = create datastore
>>>> gps.dataobject = 'dw_gps'
>>>> gps.settransobject(sqlca)
>>>>
>>>> for i = 1 to rows
>>>>
>>>> confo = trim(trips.getitemstring(i, "operator_confirmation_no"))
>>>> car_no = trim(trips.getitemstring(i, "operator_car_no"))
>>>> if car_no = "2189" then
>>>> goto done2
>>>> end if
>>>> status = trim(trips.getitemstring(i, "operator_status_flag"))
>>>> dr_no = trim(trips.getitemstring(i, "operator_dr_no"))
>>>> ld_date_time = trips.getitemdatetime(i, "operator_ld_date_time")
>>>>
>>>> geofence_dt = trips.getitemdatetime(i,
>>>> "ft_v_geofence_in_geofence_date_time")
>>>>
>>>> if isnull(geofence_dt) then //this wont be null after VR rule runs
>>>> and
>>>> sends the alert
>>>>
>>>> gps_rows = gps.retrieve(datetime_5_minutes_behind,
>>>> integer(car_no))
>>>>
>>>> if gps_rows = 1 then
>>>>
>>>> latitude = gps.getitemnumber(1, "latitude")
>>>> longitude = gps.getitemnumber(1, "longitude")
>>>> trips.setitem(i, "ft_v_geofence_car_pos_lat", latitude)
>>>> trips.setitem(i, "ft_v_geofence_car_pos_long", longitude)
>>>> trips.setitem(i, "ft_v_geofence_record_change_dt",
>>>> datetime(today(),now()))
>>>> trips.setitemstatus(i,0,Primary!, DataModified!) //update the row
>>>> else
>>>> if sequence = 8 then
>>>> uf_send_email(confo, car_no, status,ld_date_time)
>>>> end if
>>>>
>>>> INSERT INTO ft_v_gps_data_not_found
>>>> ( confirmation_no,
>>>> gps_check_date_time,
>>>> trip_status,
>>>> car_no,
>>>> dr_id )
>>>> VALUES ( :confo,
>>>> :rightnow,
>>>> :status,
>>>> :car_no,
>>>> :dr_no ) ;
>>>>
>>>> commit;
>>>>
>>>> end if
>>>>
>>>> end if
>>>>
>>>> trips.update()
>>>> commit;
>>>>
>>>> done2:
>>>>
>>>> next
>>>>
>>>> end if
>>>>
>>>> destroy trips
>>>> destroy gps
>>>>
>>>> if sequence = 4 or sequence = 8 then
>>>> uf_fire_vr_geofence_ws()
>>>> end if
>>>>
>>>> if sequence = 8 then
>>>> sequence = 0
>>>> end if
>>>>
>>>> if running = 240 then
>>>> uf_send_email_alive()
>>>> running = 0
>>>> end if
>>>>
>>>> timer(15, w_main)
>>>> ***END TIMER CODE***
>>>>
>>>> ***START UF_FIRE_GEOFENCE_WS CODE***
>>>> long rc
>>>> SoapConnection conn
>>>> p_vaa_geo_fenceservice proxy
>>>> p_vrresponse response
>>>> p_vrrequest request
>>>> string result
>>>>
>>>> conn = create SoapConnection
>>>> rc = conn.CreateInstance( proxy, "p_vaa_geo_fenceservice")
>>>>
>>>> try
>>>>
>>>> request = create p_vrrequest
>>>> request.input = create p_masterinput
>>>> request.target = create p_target
>>>> request.configuration = create p_configuration
>>>>
>>>> request.input.password = "PB"
>>>> request.target.version = "0.0.1"
>>>> //request.configuration.sessionstatistics.level = 1 //uncommenting
>>>> this
>>>> causes an exception
>>>>
>>>> response = proxy.vaa_geo_fence_webservicewrapper_master(request)
>>>>
>>>> IF NOT isValid(response) THEN
>>>> result = "Did not get a response object from the webservice"
>>>> return result
>>>> END IF
>>>>
>>>> IF NOT isValid(response.output) THEN
>>>> result = "Response Object does not contain an Output Object"
>>>> return result
>>>> END IF
>>>>
>>>> result = string(response.output.response)
>>>>
>>>> catch ( SoapException e )
>>>>
>>>> result = e.text
>>>>
>>>> end try
>>>>
>>>> destroy conn
>>>>
>>>> return result
>>>> ***END UF_FIRE_GEOFENCE_WS CODE***
>>>>
>>>>
>>>
>>
>>
>


Chris Pollach Posted on 2013-03-14 17:24:20.0Z
From: Chris Pollach <cpollach@travel-net.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20130307 Thunderbird/17.0.4
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.general
Subject: Re: Winform App Disappearing - PB 12.1 Build 7107
References: <5140684f$1@forums-1-dub> <51407231@forums-1-dub> <514079b0@forums-1-dub> <5141e8c2@forums-1-dub> <5141fc09@forums-1-dub>
In-Reply-To: <5141fc09@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <514207c4$1@forums-1-dub>
Date: 14 Mar 2013 09:24:20 -0800
X-Trace: forums-1-dub 1363281860 172.20.134.152 (14 Mar 2013 09:24:20 -0800)
X-Original-Trace: 14 Mar 2013 09:24:20 -0800, vip152.sybase.com
Lines: 330
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:249948
Article PK: 1308377

Welcome to the .Net world ... it behaves just like Mr Balmer! LOL :-)

On 3/14/2013 12:34 PM, Paul Murray wrote:
> Thanks, but this is a Winform and not a webform.
>
> The odd thing is that this is the first windows application that I have ever
> created that just decides to close down without an error message. It's
> annoying!!
>
>
> "DirtPour" <myemail@yahoo.com> wrote in message
> news:5141e8c2@forums-1-dub...
>>
>>
>> It sounds like an App pool issue similar to what we once had.
>>
>> We solved it by putting the Web form on it's own App pool.
>>
>>
>>
>> Paul Murray wrote:
>>> Thanks, Chris.
>>>
>>> In a word...No.
>>>
>>> I guess I will have to dig into that and write some sort of logging
>>> utility.
>>> Ugh. :(
>>>
>>> Thanks again.
>>>
>>> Paul
>>>
>>>
>>> "Chris Pollach" <cpollach@travel-net.com> wrote in message
>>> news:51407231@forums-1-dub...
>>>>
>>>> Hi Paul;
>>>>
>>>> 1) Do all DC's and DS's have code in the DBError, ItemError, Error and
>>>> WebService events to capture & log any DBMS or Web Service errors?
>>>>
>>>> 2) Does the TransAction Object contain code to trap & log any DBMS
>>>> errors.
>>>>
>>>> 3) Does your Application Object trap & log the SystemError event?
>>>>
>>>> --
>>>>
>>>> Regards ... Chris
>>>> President: OSUG / STD Inc.
>>>> Vice President: ISUG-TECH
>>>> Blog: http://chrispollach.blogspot.com
>>>> SourceForge: http://sourceforge.net/projects/stdfndclass
>>>> PBDJ: http://chrispollach.sys-con.com
>>>> TKD: http://www.syeoh.com
>>>>
>>>>
>>>>
>>>>
>>>> On 3/13/2013 7:51 AM, Paul Murray wrote:
>>>>> Greetings All,
>>>>>
>>>>> I have a small Winform application running on a Windows Server 2003
>>>>> Hyper-V
>>>>> machine. I have both PB Runtimes installed for version 12.1 and 12.5.
>>>>>
>>>>> It works fine for about 14 hours and then it simply disappears. There
>>>>> is
>>>>> no
>>>>> dialog box with any type of error. I can't find any type of error in
>>>>> the
>>>>> event logs except an occasional system error related to WS32Time as:
>>>>>
>>>>> "The time provider NtpClient is configured to acquire time from one or
>>>>> more
>>>>> time sources, however none of the sources are currently accessible. No
>>>>> attempt to contact a source will be made for 15 minutes. NtpClient has
>>>>> no
>>>>> source of accurate time."
>>>>>
>>>>> There is no PBTrace.log in the application directory.
>>>>>
>>>>> What the application does:
>>>>>
>>>>> 1) I have code in a timer object that fires every 60 seconds.
>>>>> 2) Two datastores are created, data is moved and the datastores are
>>>>> destroyed.
>>>>> 3) A function is called which calls a webservice.
>>>>> 4) Depending on certain results one of three different email functions
>>>>> are
>>>>> called that send out emails using some .net code.
>>>>>
>>>>> If someone can kindly suggest how to trap the error or where to find an
>>>>> error, I would really appreciate it.
>>>>>
>>>>> I have gone through all of the code that has any datastores or .net
>>>>> objects
>>>>> and made sure that I am destroying them after use.
>>>>>
>>>>> Thank you,
>>>>>
>>>>> Paul
>>>>>
>>>>> Here is the primary code that fires in the timer object:
>>>>>
>>>>> ***START TIMER CODE***
>>>>> timer(0, w_main)
>>>>>
>>>>> running = running + 1
>>>>> sequence = sequence + 1
>>>>>
>>>>> st_1.text = string(datetime(today(),now()))
>>>>>
>>>>> long i
>>>>> long rows
>>>>> string car_no
>>>>> string geo_car_no
>>>>> string confo
>>>>> string geofence_confo
>>>>> datetime req_date_time
>>>>>
>>>>> datastore trips
>>>>> trips = create datastore
>>>>> trips.dataobject = 'dw_monitor_eligible_trips'
>>>>> trips.settransobject(sqlca)
>>>>> rows = trips.retrieve()
>>>>>
>>>>> if rows > 0 then
>>>>>
>>>>> for i = 1 to rows
>>>>>
>>>>> confo = trim(trips.getitemstring(i, "operator_confirmation_no"))
>>>>> req_date_time = trips.getitemdatetime(i, "operator_req_date_time")
>>>>> car_no = trim(trips.getitemstring(i, "operator_car_no"))
>>>>> if car_no = "2189" then
>>>>> goto done
>>>>> end if
>>>>> geofence_confo = trim(trips.getitemstring(i,
>>>>> "ft_v_geofence_confirmation_no"))
>>>>> geo_car_no = trim(trips.getitemstring(i, "ft_v_geofence_car_no"))
>>>>>
>>>>> if isnull(geofence_confo) then
>>>>>
>>>>> trips.setitem(i, "ft_v_geofence_confirmation_no", confo)
>>>>> trips.setitem(i, "ft_v_geofence_car_no", car_no)
>>>>> trips.setitem(i, "ft_v_geofence_record_insert_dt",
>>>>> datetime(today(),now()))
>>>>> trips.setitem(i, "ft_v_geofence_req_date_time", req_date_time)
>>>>>
>>>>> trips.setitemstatus(i,0,Primary!, NewModified!) //insert the row
>>>>> //dw_1.setitemstatus(i,0,Primary!, DataModified!) //update the row
>>>>> //dw_1.setitemstatus(i,0,Primary!, NotModified!) //don't do
>>>>> anything
>>>>>
>>>>> elseif car_no <> geo_car_no then
>>>>>
>>>>> trips.setitem(i, "ft_v_geofence_car_no", car_no)
>>>>> trips.setitem(i, "ft_v_geofence_record_change_dt",
>>>>> datetime(today(),now()))
>>>>> trips.setitemstatus(i,0,Primary!, DataModified!) //update the row
>>>>>
>>>>> end if
>>>>>
>>>>> trips.update()
>>>>> commit;
>>>>>
>>>>> done:
>>>>>
>>>>> next
>>>>>
>>>>> datetime rightnow
>>>>> rightnow = datetime(today(),now())
>>>>> datetime datetime_5_minutes_behind
>>>>> datetime_5_minutes_behind =
>>>>> uf_calc_new_date_time_from_horizon_minus(rightnow, -5)
>>>>>
>>>>> long gps_rows
>>>>> datetime geofence_dt
>>>>> double latitude
>>>>> double longitude
>>>>> string status
>>>>> string dr_no
>>>>> datetime ld_date_time
>>>>>
>>>>> datastore gps
>>>>> gps = create datastore
>>>>> gps.dataobject = 'dw_gps'
>>>>> gps.settransobject(sqlca)
>>>>>
>>>>> for i = 1 to rows
>>>>>
>>>>> confo = trim(trips.getitemstring(i, "operator_confirmation_no"))
>>>>> car_no = trim(trips.getitemstring(i, "operator_car_no"))
>>>>> if car_no = "2189" then
>>>>> goto done2
>>>>> end if
>>>>> status = trim(trips.getitemstring(i, "operator_status_flag"))
>>>>> dr_no = trim(trips.getitemstring(i, "operator_dr_no"))
>>>>> ld_date_time = trips.getitemdatetime(i, "operator_ld_date_time")
>>>>>
>>>>> geofence_dt = trips.getitemdatetime(i,
>>>>> "ft_v_geofence_in_geofence_date_time")
>>>>>
>>>>> if isnull(geofence_dt) then //this wont be null after VR rule runs
>>>>> and
>>>>> sends the alert
>>>>>
>>>>> gps_rows = gps.retrieve(datetime_5_minutes_behind,
>>>>> integer(car_no))
>>>>>
>>>>> if gps_rows = 1 then
>>>>>
>>>>> latitude = gps.getitemnumber(1, "latitude")
>>>>> longitude = gps.getitemnumber(1, "longitude")
>>>>> trips.setitem(i, "ft_v_geofence_car_pos_lat", latitude)
>>>>> trips.setitem(i, "ft_v_geofence_car_pos_long", longitude)
>>>>> trips.setitem(i, "ft_v_geofence_record_change_dt",
>>>>> datetime(today(),now()))
>>>>> trips.setitemstatus(i,0,Primary!, DataModified!) //update the row
>>>>> else
>>>>> if sequence = 8 then
>>>>> uf_send_email(confo, car_no, status,ld_date_time)
>>>>> end if
>>>>>
>>>>> INSERT INTO ft_v_gps_data_not_found
>>>>> ( confirmation_no,
>>>>> gps_check_date_time,
>>>>> trip_status,
>>>>> car_no,
>>>>> dr_id )
>>>>> VALUES ( :confo,
>>>>> :rightnow,
>>>>> :status,
>>>>> :car_no,
>>>>> :dr_no ) ;
>>>>>
>>>>> commit;
>>>>>
>>>>> end if
>>>>>
>>>>> end if
>>>>>
>>>>> trips.update()
>>>>> commit;
>>>>>
>>>>> done2:
>>>>>
>>>>> next
>>>>>
>>>>> end if
>>>>>
>>>>> destroy trips
>>>>> destroy gps
>>>>>
>>>>> if sequence = 4 or sequence = 8 then
>>>>> uf_fire_vr_geofence_ws()
>>>>> end if
>>>>>
>>>>> if sequence = 8 then
>>>>> sequence = 0
>>>>> end if
>>>>>
>>>>> if running = 240 then
>>>>> uf_send_email_alive()
>>>>> running = 0
>>>>> end if
>>>>>
>>>>> timer(15, w_main)
>>>>> ***END TIMER CODE***
>>>>>
>>>>> ***START UF_FIRE_GEOFENCE_WS CODE***
>>>>> long rc
>>>>> SoapConnection conn
>>>>> p_vaa_geo_fenceservice proxy
>>>>> p_vrresponse response
>>>>> p_vrrequest request
>>>>> string result
>>>>>
>>>>> conn = create SoapConnection
>>>>> rc = conn.CreateInstance( proxy, "p_vaa_geo_fenceservice")
>>>>>
>>>>> try
>>>>>
>>>>> request = create p_vrrequest
>>>>> request.input = create p_masterinput
>>>>> request.target = create p_target
>>>>> request.configuration = create p_configuration
>>>>>
>>>>> request.input.password = "PB"
>>>>> request.target.version = "0.0.1"
>>>>> //request.configuration.sessionstatistics.level = 1 //uncommenting
>>>>> this
>>>>> causes an exception
>>>>>
>>>>> response = proxy.vaa_geo_fence_webservicewrapper_master(request)
>>>>>
>>>>> IF NOT isValid(response) THEN
>>>>> result = "Did not get a response object from the webservice"
>>>>> return result
>>>>> END IF
>>>>>
>>>>> IF NOT isValid(response.output) THEN
>>>>> result = "Response Object does not contain an Output Object"
>>>>> return result
>>>>> END IF
>>>>>
>>>>> result = string(response.output.response)
>>>>>
>>>>> catch ( SoapException e )
>>>>>
>>>>> result = e.text
>>>>>
>>>>> end try
>>>>>
>>>>> destroy conn
>>>>>
>>>>> return result
>>>>> ***END UF_FIRE_GEOFENCE_WS CODE***
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>


Andreas Mykonios Posted on 2013-03-15 19:39:16.0Z
From: Andreas Mykonios <Andreas Mykonios>
Newsgroups: sybase.public.powerbuilder.general
Subject: Re: Winform App Disappearing - PB 12.1 Build 7107
Message-ID: <46u6k8dktivvmf8ssfgh03iolrut0q2lgk@4ax.com>
References: <5140684f$1@forums-1-dub> <51407231@forums-1-dub> <514079b0@forums-1-dub> <5141e8c2@forums-1-dub> <5141fc09@forums-1-dub> <514207c4$1@forums-1-dub>
X-Newsreader: Forte Agent 4.2/32.1118
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 15 Mar 2013 11:39:16 -0800
X-Trace: forums-1-dub 1363376356 172.20.134.152 (15 Mar 2013 11:39:16 -0800)
X-Original-Trace: 15 Mar 2013 11:39:16 -0800, vip152.sybase.com
Lines: 336
X-Authenticated-User: pb125beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.general:249964
Article PK: 1308417

That's an opinion...

Andreas.

On 14 Mar 2013 09:24:20 -0800, Chris Pollach <cpollach@travel-net.com>

wrote:

>
>Welcome to the .Net world ... it behaves just like Mr Balmer! LOL :-)
>
>
>On 3/14/2013 12:34 PM, Paul Murray wrote:
>> Thanks, but this is a Winform and not a webform.
>>
>> The odd thing is that this is the first windows application that I have ever
>> created that just decides to close down without an error message. It's
>> annoying!!
>>
>>
>> "DirtPour" <myemail@yahoo.com> wrote in message
>> news:5141e8c2@forums-1-dub...
>>>
>>>
>>> It sounds like an App pool issue similar to what we once had.
>>>
>>> We solved it by putting the Web form on it's own App pool.
>>>
>>>
>>>
>>> Paul Murray wrote:
>>>> Thanks, Chris.
>>>>
>>>> In a word...No.
>>>>
>>>> I guess I will have to dig into that and write some sort of logging
>>>> utility.
>>>> Ugh. :(
>>>>
>>>> Thanks again.
>>>>
>>>> Paul
>>>>
>>>>
>>>> "Chris Pollach" <cpollach@travel-net.com> wrote in message
>>>> news:51407231@forums-1-dub...
>>>>>
>>>>> Hi Paul;
>>>>>
>>>>> 1) Do all DC's and DS's have code in the DBError, ItemError, Error and
>>>>> WebService events to capture & log any DBMS or Web Service errors?
>>>>>
>>>>> 2) Does the TransAction Object contain code to trap & log any DBMS
>>>>> errors.
>>>>>
>>>>> 3) Does your Application Object trap & log the SystemError event?
>>>>>
>>>>> --
>>>>>
>>>>> Regards ... Chris
>>>>> President: OSUG / STD Inc.
>>>>> Vice President: ISUG-TECH
>>>>> Blog: http://chrispollach.blogspot.com
>>>>> SourceForge: http://sourceforge.net/projects/stdfndclass
>>>>> PBDJ: http://chrispollach.sys-con.com
>>>>> TKD: http://www.syeoh.com
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On 3/13/2013 7:51 AM, Paul Murray wrote:
>>>>>> Greetings All,
>>>>>>
>>>>>> I have a small Winform application running on a Windows Server 2003
>>>>>> Hyper-V
>>>>>> machine. I have both PB Runtimes installed for version 12.1 and 12.5.
>>>>>>
>>>>>> It works fine for about 14 hours and then it simply disappears. There
>>>>>> is
>>>>>> no
>>>>>> dialog box with any type of error. I can't find any type of error in
>>>>>> the
>>>>>> event logs except an occasional system error related to WS32Time as:
>>>>>>
>>>>>> "The time provider NtpClient is configured to acquire time from one or
>>>>>> more
>>>>>> time sources, however none of the sources are currently accessible. No
>>>>>> attempt to contact a source will be made for 15 minutes. NtpClient has
>>>>>> no
>>>>>> source of accurate time."
>>>>>>
>>>>>> There is no PBTrace.log in the application directory.
>>>>>>
>>>>>> What the application does:
>>>>>>
>>>>>> 1) I have code in a timer object that fires every 60 seconds.
>>>>>> 2) Two datastores are created, data is moved and the datastores are
>>>>>> destroyed.
>>>>>> 3) A function is called which calls a webservice.
>>>>>> 4) Depending on certain results one of three different email functions
>>>>>> are
>>>>>> called that send out emails using some .net code.
>>>>>>
>>>>>> If someone can kindly suggest how to trap the error or where to find an
>>>>>> error, I would really appreciate it.
>>>>>>
>>>>>> I have gone through all of the code that has any datastores or .net
>>>>>> objects
>>>>>> and made sure that I am destroying them after use.
>>>>>>
>>>>>> Thank you,
>>>>>>
>>>>>> Paul
>>>>>>
>>>>>> Here is the primary code that fires in the timer object:
>>>>>>
>>>>>> ***START TIMER CODE***
>>>>>> timer(0, w_main)
>>>>>>
>>>>>> running = running + 1
>>>>>> sequence = sequence + 1
>>>>>>
>>>>>> st_1.text = string(datetime(today(),now()))
>>>>>>
>>>>>> long i
>>>>>> long rows
>>>>>> string car_no
>>>>>> string geo_car_no
>>>>>> string confo
>>>>>> string geofence_confo
>>>>>> datetime req_date_time
>>>>>>
>>>>>> datastore trips
>>>>>> trips = create datastore
>>>>>> trips.dataobject = 'dw_monitor_eligible_trips'
>>>>>> trips.settransobject(sqlca)
>>>>>> rows = trips.retrieve()
>>>>>>
>>>>>> if rows > 0 then
>>>>>>
>>>>>> for i = 1 to rows
>>>>>>
>>>>>> confo = trim(trips.getitemstring(i, "operator_confirmation_no"))
>>>>>> req_date_time = trips.getitemdatetime(i, "operator_req_date_time")
>>>>>> car_no = trim(trips.getitemstring(i, "operator_car_no"))
>>>>>> if car_no = "2189" then
>>>>>> goto done
>>>>>> end if
>>>>>> geofence_confo = trim(trips.getitemstring(i,
>>>>>> "ft_v_geofence_confirmation_no"))
>>>>>> geo_car_no = trim(trips.getitemstring(i, "ft_v_geofence_car_no"))
>>>>>>
>>>>>> if isnull(geofence_confo) then
>>>>>>
>>>>>> trips.setitem(i, "ft_v_geofence_confirmation_no", confo)
>>>>>> trips.setitem(i, "ft_v_geofence_car_no", car_no)
>>>>>> trips.setitem(i, "ft_v_geofence_record_insert_dt",
>>>>>> datetime(today(),now()))
>>>>>> trips.setitem(i, "ft_v_geofence_req_date_time", req_date_time)
>>>>>>
>>>>>> trips.setitemstatus(i,0,Primary!, NewModified!) //insert the row
>>>>>> //dw_1.setitemstatus(i,0,Primary!, DataModified!) //update the row
>>>>>> //dw_1.setitemstatus(i,0,Primary!, NotModified!) //don't do
>>>>>> anything
>>>>>>
>>>>>> elseif car_no <> geo_car_no then
>>>>>>
>>>>>> trips.setitem(i, "ft_v_geofence_car_no", car_no)
>>>>>> trips.setitem(i, "ft_v_geofence_record_change_dt",
>>>>>> datetime(today(),now()))
>>>>>> trips.setitemstatus(i,0,Primary!, DataModified!) //update the row
>>>>>>
>>>>>> end if
>>>>>>
>>>>>> trips.update()
>>>>>> commit;
>>>>>>
>>>>>> done:
>>>>>>
>>>>>> next
>>>>>>
>>>>>> datetime rightnow
>>>>>> rightnow = datetime(today(),now())
>>>>>> datetime datetime_5_minutes_behind
>>>>>> datetime_5_minutes_behind =
>>>>>> uf_calc_new_date_time_from_horizon_minus(rightnow, -5)
>>>>>>
>>>>>> long gps_rows
>>>>>> datetime geofence_dt
>>>>>> double latitude
>>>>>> double longitude
>>>>>> string status
>>>>>> string dr_no
>>>>>> datetime ld_date_time
>>>>>>
>>>>>> datastore gps
>>>>>> gps = create datastore
>>>>>> gps.dataobject = 'dw_gps'
>>>>>> gps.settransobject(sqlca)
>>>>>>
>>>>>> for i = 1 to rows
>>>>>>
>>>>>> confo = trim(trips.getitemstring(i, "operator_confirmation_no"))
>>>>>> car_no = trim(trips.getitemstring(i, "operator_car_no"))
>>>>>> if car_no = "2189" then
>>>>>> goto done2
>>>>>> end if
>>>>>> status = trim(trips.getitemstring(i, "operator_status_flag"))
>>>>>> dr_no = trim(trips.getitemstring(i, "operator_dr_no"))
>>>>>> ld_date_time = trips.getitemdatetime(i, "operator_ld_date_time")
>>>>>>
>>>>>> geofence_dt = trips.getitemdatetime(i,
>>>>>> "ft_v_geofence_in_geofence_date_time")
>>>>>>
>>>>>> if isnull(geofence_dt) then //this wont be null after VR rule runs
>>>>>> and
>>>>>> sends the alert
>>>>>>
>>>>>> gps_rows = gps.retrieve(datetime_5_minutes_behind,
>>>>>> integer(car_no))
>>>>>>
>>>>>> if gps_rows = 1 then
>>>>>>
>>>>>> latitude = gps.getitemnumber(1, "latitude")
>>>>>> longitude = gps.getitemnumber(1, "longitude")
>>>>>> trips.setitem(i, "ft_v_geofence_car_pos_lat", latitude)
>>>>>> trips.setitem(i, "ft_v_geofence_car_pos_long", longitude)
>>>>>> trips.setitem(i, "ft_v_geofence_record_change_dt",
>>>>>> datetime(today(),now()))
>>>>>> trips.setitemstatus(i,0,Primary!, DataModified!) //update the row
>>>>>> else
>>>>>> if sequence = 8 then
>>>>>> uf_send_email(confo, car_no, status,ld_date_time)
>>>>>> end if
>>>>>>
>>>>>> INSERT INTO ft_v_gps_data_not_found
>>>>>> ( confirmation_no,
>>>>>> gps_check_date_time,
>>>>>> trip_status,
>>>>>> car_no,
>>>>>> dr_id )
>>>>>> VALUES ( :confo,
>>>>>> :rightnow,
>>>>>> :status,
>>>>>> :car_no,
>>>>>> :dr_no ) ;
>>>>>>
>>>>>> commit;
>>>>>>
>>>>>> end if
>>>>>>
>>>>>> end if
>>>>>>
>>>>>> trips.update()
>>>>>> commit;
>>>>>>
>>>>>> done2:
>>>>>>
>>>>>> next
>>>>>>
>>>>>> end if
>>>>>>
>>>>>> destroy trips
>>>>>> destroy gps
>>>>>>
>>>>>> if sequence = 4 or sequence = 8 then
>>>>>> uf_fire_vr_geofence_ws()
>>>>>> end if
>>>>>>
>>>>>> if sequence = 8 then
>>>>>> sequence = 0
>>>>>> end if
>>>>>>
>>>>>> if running = 240 then
>>>>>> uf_send_email_alive()
>>>>>> running = 0
>>>>>> end if
>>>>>>
>>>>>> timer(15, w_main)
>>>>>> ***END TIMER CODE***
>>>>>>
>>>>>> ***START UF_FIRE_GEOFENCE_WS CODE***
>>>>>> long rc
>>>>>> SoapConnection conn
>>>>>> p_vaa_geo_fenceservice proxy
>>>>>> p_vrresponse response
>>>>>> p_vrrequest request
>>>>>> string result
>>>>>>
>>>>>> conn = create SoapConnection
>>>>>> rc = conn.CreateInstance( proxy, "p_vaa_geo_fenceservice")
>>>>>>
>>>>>> try
>>>>>>
>>>>>> request = create p_vrrequest
>>>>>> request.input = create p_masterinput
>>>>>> request.target = create p_target
>>>>>> request.configuration = create p_configuration
>>>>>>
>>>>>> request.input.password = "PB"
>>>>>> request.target.version = "0.0.1"
>>>>>> //request.configuration.sessionstatistics.level = 1 //uncommenting
>>>>>> this
>>>>>> causes an exception
>>>>>>
>>>>>> response = proxy.vaa_geo_fence_webservicewrapper_master(request)
>>>>>>
>>>>>> IF NOT isValid(response) THEN
>>>>>> result = "Did not get a response object from the webservice"
>>>>>> return result
>>>>>> END IF
>>>>>>
>>>>>> IF NOT isValid(response.output) THEN
>>>>>> result = "Response Object does not contain an Output Object"
>>>>>> return result
>>>>>> END IF
>>>>>>
>>>>>> result = string(response.output.response)
>>>>>>
>>>>>> catch ( SoapException e )
>>>>>>
>>>>>> result = e.text
>>>>>>
>>>>>> end try
>>>>>>
>>>>>> destroy conn
>>>>>>
>>>>>> return result
>>>>>> ***END UF_FIRE_GEOFENCE_WS CODE***
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>