Datastore Update Error
Contents |
from GoogleSign inHidden fieldsSearch for groups or messages
Developer CenterWhere is this place located?All Places SAP Developer Center PowerBuilder Developer Center 15 Replies Latest reply: Feb 4, 2015 7:15 PM by Jim Egan Tweet app engine deadlineexceedederror Datastore Retrieve Returns -1 Jim Egan Feb 4, 2015 6:41
Process Terminated Because The Request Deadline Was Exceeded. (error Code 123)
AM Currently Being Moderated It's been a while since I did a lot of serious PB
Google App Engine Server Error
coding and I'm back to making newbie mistakes. This is classic PB 12.5 with the client running on Windows Vista against an Oracle database.When I try to https://groups.google.com/d/topic/powersoft.public.powerbuilder.datawindow/KiwgeybTkMY retrieve my datastore the return value is -1. ltr_trans = Create transactionltr_trans.DBMS = SQLCA.DBMSltr_trans.LogPass = SQLCA.LogPassltr_trans.ServerName = SQLCA.ServerNameltr_trans.LogId = SQLCA.LogIdltr_trans.AutoCommit = SQLCA.AutoCommitltr_trans.DBParm = SQLCA.DBParmConnect Using ltr_trans;If ltr_trans.SQLCode = -1 THEN MessageBox("Database Connect Error", ltr_trans.SQLErrText) ReturnEnd If// Set up the PLAYER_HISTORY tablelds_last_change = CREATE datastorelds_last_change.dataobject = 'dw_player_history_by_player'If (lds_last_change.SetTransObject(ltr_trans) = -1) Then MessageBox('SetTransObject Failure', https://scn.sap.com/thread/3690735 lds_last_change.dataobject + ' Failed') ReturnEnd If...........// Retrieve the player into the datastoreli_PlayerCount = lds_last_change.Retrieve(ls_PlayerAbbr)// Check for a retrieve errorIf li_PlayerCount = -1 Then MessageBox('Datawindow Retrieve Failure', 'Error: ' + ltr_trans.SQLErrText ) ExitEnd If1. The SQLCA connection is working. There are DataWindows in the the same Window that are retrieving data OK. So the connection information is good.2. There are no errors in the ltr_trans object.3. There is no error when calling SetTransObject().4. The Dataflow retrieves fine in the design mode. It retrieves a single row using the same argument the script is using.5. I've gone through the debugger and everything looks like I expect it to.It has to be something simple that I'm not remembering.Jim EganSenior ConsultantProKarma, Inc. 698Views Tagsnone (add) Tags: datastore, retrieve Re: Datastore Retrieve Returns -1 Roland Smith Feb 4, 2015 8:31 AM (in response to Jim Egan) Currently Being Moderated You probably need to create a .pbr file with a reference to the DataWindow
can also call AcceptText for the current row and column before it updates the database. UpdateEx A separate method name, UpdateEx, is provided as an alternative syntax for the Web DataWindow server component, which cannot use overloaded methods. http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc37783.1252/html/dwref/CAIEBDAJ.htm Applies to DataWindow type Method applies to PowerBuilder DataWindow control, DataWindowChild object, DataStore object https://blogs.technet.microsoft.com/trentsh/2010/08/12/error-number-0x8024800c-running-windows-update/ Web Client control, server component Web ActiveX DataWindow control, DataWindowChild object Syntax PowerBuilder integer dwcontrol.Update ( { boolean accept {, boolean resetflag } } ) Web DataWindow client control number dwcontrol.Update ( ) Web DataWindow server component short dwcontrol.Update ( ) short dwcontrol.UpdateEx ( boolean accept, boolean resetflag ) Web ActiveX number dwcontrol.Update ( { boolean accept server error {, boolean resetflag } } ) Argument Description dwcontrol A reference to a DataWindow control, DataStore, or child DataWindow. accept (optional) A boolean value specifying whether the DataWindow control or DataStore should automatically perform an AcceptText prior to performing the update: True – (Default) Perform AcceptText. The update is canceled if the data fails validation. False – Do not perform AcceptText. resetflag (optional) A boolean value specifying whether dwcontrol should automatically reset 500 server error the update flags: True – (Default) Reset the flags. False – Do not reset the flags. Returns Returns 1 if it succeeds and –1 if an error occurs. If any argument’s value is null, Update returns null. If there is no DataWindow object assigned to the DataWindow control or DataStore, this method returns 1. Usage In PowerBuilder, you must use the SetTrans or the SetTransObject method to specify the database connection before the Update method will execute. When you use SetTransObject, the more efficient of the two, you must do your own transaction management, which includes issuing the SQL COMMIT or ROLLBACK statement to finalize the update. Test success/failure code It is good practice to test the success/failure code after calling Update. You can also verify the number of rows inserted, updated, and deleted by a DataWindow update by examining the values of the arguments of the UpdateEnd event. By default, Update resets the update flags after successfully completing the update. However, you can prevent the flags from being reset until you perform other validations and commit the changes. When you are satisfied with the update, call ResetUpdate to clear the flags so that items are no longer marked as modified. Use SetTransObject when resetflag is False You would typically use SetTransObject, not Se
12, 201012 0 0 0 Trent Here, I recently ran into a problem on some machines that were failing to run windows update. The web service would fail with the following [Error number: 0x8024800C] I found several posts related to connection errors between a proxy server and firewall settings however none of these applied to my scenario. Looking at the windowsupdate.log file didn't help much either: I was able to find the following:http://technet.microsoft.com/en-us/library/cc720442(WS.10).aspxon the Windows Update Agent Result codes Data Store0x8024800C WU_E_DS_LOCKTIMEOUTEXPIRED The data store section could not be locked within the allotted time. So the "Data Store" is actually C:\Windows\SoftwareDistribution\DataStore. Interesting.http://support.microsoft.com/kb/971058. The article was not identicle to what I was seeing but gave me some good ideas ***************Resolution*************** From a command line - net stop "Automatic Updates" del C:\Windows\SoftwareDistribution\ net start "Automatic Updates" After that I simply ranwindowsupate again and it worked perfectly. TrentCISSP, ITILv3, MCP This posting is provided "AS IS" with no warranties, and confers no rights. Tags 0x8024800C Error Windows update download [Error number: 0x8024800C] Comments (12) Cancel reply Name * Email * Website Anonymous says: October 6, 2016 at 2:15 pm In Windows 7, change "Automatic Updates" to "Windows Updates". I made that minor modification and your tip worked perfectly. Thank you! Reply trentsh says: October 6, 2016 at 2:15 pm glad to see this is helping some folks. Reply Cole says: December 29, 2011 at 2:54 pm Thank you very much, this fixed my issue on multiple servers! Reply jesse says: September 24, 2012 at 6:05 pm Worked as stated thanks! Reply B says: November 12, 2012 at 8:26 am Nice! Reply Denis says: March 16, 2013 at 6:21 pm Thanks! Спасибо! Reply Mark says: March 16, 2013 at 11:45 pm Thanks! Fix worked great on my Win 7×64 laptop. Should note that it can take extra long to run the updates right after the fix, but that is small price to pay to get things working again. Reply thomas says: March 17, 2013 at 7:16 am This fixed my code 8024800a as well, which microsofts self repair tools couldn't fix. Thanks a lot. Reply SH says: March 17, 2013 at 1:44 pm Thanks a lot, that worked perfectly and safed a lot of time!! Reply Rajan Thakur says: August