Error Number 10509
as Inappropriate ♦ ♦ Error Code -10509 Hi, I would like to seek some feedback regarding an error code in a v11 Windows application. This morning, my customer encountered an error when their users tried to log in. The error code is -10509, further details indicated a #-50 error. According to the manual, -10509 refers to a "Can't open database" error. Not really useful. As such, no user could log in to the database. When I quit 4D server service and opened the application in single-user mode, the backup dialog showed. No problems to data and structure. Restarted the service and all users could log in. Therein lies my questions: 1. When backup (on 4D server) is in progress, can any client log in to the database? 2. If backup stalls, does it cause a -10509 error? 3. The backup is scheduled on 4D Server, running daily at 0200hours. Why should a backup stall? And if it stalls, why does it continue when the database is launched in single-user mode. Regards, Ronnie Teo Tarawerkz ********************************************************************** The New 4D Partner Program - All the tools you need to be a successful 4D Developer. Sign up Now: http://www.4d.com/community/partner/registration.html 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.htmlArchive: http://lists.4d.com/archives.htmlOptions: https://lists.4d.com/mailman/options/4d_techUnsub: mailto:[hidden email] ********************************************************************** Spencer Hinsdale Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Re: Error Code -10509 On 5/30/10 11:20 PM, "Ronnie Teo" <[hidden email]> wrote: > Hi, > > I would like to seek some feedback regarding an error code in a v11 Windows > application. This morning, my customer encountered an error when their > users tried to log in. The error code is -10509, further details indicated a > #-50 error. According to the manual, -10509 refers to a "Can't open > database" error. Not really useful. > One possible cause is that the DB4D port is blocked. If the Server is running on port 19813, port 19814 must also be open (or whatever port is used for application server + 1). -spencer ********************************************************************** The New 4D Partner Program - All the tools you need to be a successful 4D Developer. Sign up Now: http://www.4d.com/community/partner/registration.html 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.htmlArchive: http://lists.4d.com/archives.htmlOptions: https://lists.4d.com/mail
Sybase Support Portal SAP PartnerEdge SAP Training & Certification Shop SAP Service Marketplace SAP Store Analytics Content and Collaboration Customer Relationship Mgmt Data Management Enterprise Management Financial Management Human Capital Management Product Lifecycle Mgmt Supplier Relationship Mgmt Supply Chain Management Technology Platform Additional Information Enterprise Management SAP ERP 6.0 Basic Information Basic Information Concepts of the Database System Glossary SQL Reference Manual Messages Number ranges From -1 to -699 From -900 to -999 From -1000 to -1999 From -2000 to -2999 From -3000 to -3999 From -4000 to -4999 From -5000 to -5999 http://4d.1045681.n5.nabble.com/Error-Code-10509-td1396737.html From -6000 to -6999 From -7000 to -7999 From -8000 to -9799 From -10000 to -10999 -10001: System error:
Sybase Support Portal SAP PartnerEdge SAP Training & Certification Shop SAP Service Marketplace SAP Store Analytics Content and Collaboration Customer Relationship Mgmt https://help.sap.com/saphelp_nw74/helpdata/en/5b/5f0e6263a040fab02abd45919144c1/content.htm Data Management Enterprise Management Financial Management Human Capital Management Product Lifecycle Mgmt Supplier Relationship Mgmt Supply Chain Management Technology Platform Additional Information Technology Platform SAP NetWeaver 7.4 Messages Messages Number http://kb.4d.com/search/assetid=76125 Ranges From -1 to -699 From -700 to -899 From -900 to -999 From -1000 to -1999 From -2000 to -2999 From -3000 to -3999 From -4000 to -4999 error number From -5000 to -5999 From -6000 to -6999 From -7000 to -7999 From -8000 to -9799 From -10000 to -10999 -10001: System error:
component method is tokenized in the database then that component must be available in the components directory.If the component is not found a -10509 error will be displayed and the user is notified that a component is missing.If the component has been renamed, a -10509 error will be displayed :: Renaming the .4DC file of the component to the earlier name used during compilation can be a temporary workaround; you can change it's name before your next compiling of the Host database.The error will look like this (replace the database name and component name with applicable values):To avoid this, you must avoid directly using a Component's method in the Host database, because they are tokenized, and require that the component is there.One approach is to use EXECUTE FORMULA to execute shared methods.For example, the following code has the Component method "myComp_method1" tokenized:ARRAY TEXT($Components_at;0)COMPONENT LIST($Components_at)If (Size of array($Components_at)>0)If (Find in array($Components_at;"myComponent@")>0)C_LONGINT(count_li)C_TEXT(text_t)C_TEXT($0;out_t)count_li:=10text_t:="Test!"out_t:=myComp_method1 (text_t;count_li)$0:=out_tEnd if End ifThe above example has the component method tokenized which should be avoided if you want to be able to replace or remove the component database without seeing the -10509 error. This code can be re-written like this:ARRAY TEXT($Components_at;0)COMPONENT LIST($Components_at)If (Size of array($Components_at)>0)If (Find in array($Components_at;"myComponent@")>0)C_LONGINT(count_li)C_TEXT(text_t)C_TEXT($0;out_t)count_li:=10text_t:="Test!"C_TEXT($execThis)$execThis:="out_t:=myComp_method1 (text_t;count_li)"EXECUTE FORMULA($execThis)$0:=out_tEnd if End ifIn this case you have no shared component methods tokenized in the Host database, and you will avoid these errors. Commented by Thomas Maul on July 21, 2010 at 5:21 AM Another way is to use the command EXECUTE METHOD: http://doc.4d.com/4Dv11.6/help/command/en/page1007.html which calls directly a method and passes the parameters, while EXECUTE FORMULA first s