Unfortunately, this option did not help. The result is the same. ... View more

My question was not about the largest number sas can work with. The question was why 16-digit numbers (for example, var = 1111111111111111, and it is less than the maximum) when loading into Oracle database, rounds the last digit in the number. If you have a test database, you can try to reproduce this. In the database, this number will be displayed as 111111111111111110. ... View more

Data uploading works incorrectly according to the following algorithm:   SAS  =>> Oracle DB (round last digit in 16-digit numbers)   Now I tried to upload data in format 17 as follows: data work.test_tbl; format t1 t2 t3 t4 t5 t6 t7 t8 t9 17.; t1 = 1111111111111111; t2 = 2222222222222222; t3 = 3333333333333333; t4 = 4444444444444444; t5 = 5555555555555555; t6 = 6666666666666666; t7 = 7777777777777777; t8 = 8888888888888888; t9 = 9999999999999999; run; proc sql; create table oracle_lib.test_tbl AS SELECT * FROM work.test_tbl; quit; The result is the same:   although the format in the database table corresponds to what was specified in SAS. ... View more

Thank you, but as I wrote earlier, the option of downloading a text format is not currently considered. Reproducing Steps: 1. Create a dataset with 16-digit numeric variables. 2. Upload it to Oracle through "Create table ... as select * from dataset_from_step_N1 " or through the sqlldr utility - it does not matter. 3. Make sure that in the database the last digit of the number is rounded.   If you create a dataset in SAS based on what was done in step one, through "Create table ... as select * from dataset_from_step_N1", you can see that numbers less than 9,007,199,254,740,992 (as stated in the documentation) are not rounded. ... View more

Unfortunately, the source of the table is numerical data, not text. This upload to the database is an integral part of a larger and more complex process. In the description of the problem, I just gave an example of how to reproduce this problem. ... View more

Is there a documented statement that the length of a number in cac is 15 digits? By searching the sas documentation, I found information that sas can work with a maximum of 8 byte numbers (the maximum number is 9,007,199,254,740,992). This is just the same confirmed by the first case from the description of the problem (all numbers are displayed correctly except 9999999999999999). Problems begin to appear only when uploading to Oracle Database. ... View more

Hi!   Tell me, please, have you solved this problem? We encountered the same error. ... View more

Hi, @JuanS_OCS!   Yes, started a support task. Unfortunately, there is no answer yet. If something new is known, I will definitely inform you in the track. ... View more

Hi, @JuanS_OCS!   Yes, I thought so too at first. But there is one problem: There is one more environment with exactly the same license. The same error occurs in the Framework Data Server logs - with a license, but the server starts without problems and the SAS EM application is running. ... View more

Hi, @JuanS_OCS!   Yeah right that's SAS 9.3.   It seems to me as one of your WIP services is not starting OK   -Yes, WIP & Workflow services cannot deploy on the SASServer1:   --- MBeans waiting for other MBeans --- ObjectName: jboss.web.deployment:war=sas.wip.services.war,id=638445318 State: FAILED Reason: org.jboss.deployment.DeploymentException: URL file:/sas/jboss-4.2.3.GA/server/SASServer1/deploy_sas/sas.wip.services9.3.ear/sas.wip.services.war/ deployment failed ObjectName: jboss.web.deployment:war=sas.workflow.war,id=-1558281180 State: FAILED Reason: org.jboss.deployment.DeploymentException: URL file:/sas/jboss-4.2.3.GA/server/SASServer1/deploy_sas/sas.workflow9.3.ear/sas.workflow.war/ deployment failed --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- ObjectName: jboss.web.deployment:war=sas.workflow.war,id=-1558281180 State: FAILED Reason: org.jboss.deployment.DeploymentException: URL file:/sas/jboss-4.2.3.GA/server/SASServer1/deploy_sas/sas.workflow9.3.ear/sas.workflow.war/ deployment failed ObjectName: jboss.web.deployment:war=sas.wip.services.war,id=638445318 State: FAILED Reason: org.jboss.deployment.DeploymentException: URL file:/sas/jboss-4.2.3.GA/server/SASServer1/deploy_sas/sas.wip.services9.3.ear/sas.wip.services.war/ deployment failed This is because I can not correctly run Framework Data Server.  Here is the extended log when I try to run it.   , OS: 'LIN X64', Release: '2.6.32-220.el6.x86_64', SAS Version: '', Command: '/sas/SAS93/dfs/lib/tkesrv -set TKPATH /sas/SAS93/dfs/lib -config /sas/sasconfig/Lev1/FrameworkServer/dffedsvrcfg/dfs_serv.xml -logconfigloc /sas/sasconfig/Lev1/FrameworkServer/dffedsvrcfg/dfs_log.xml' 2018-10-25T15:13:09,082 INFO [00000004] Cradle :sas - TKCRADLE version 1.0.0 is initializing. 2018-10-25T15:13:09,093 DEBUG [00000004] Cradle :sas - The command line arguments received are: 2018-10-25T15:13:09,093 DEBUG [00000004] Cradle :sas - [0]: /sas/SAS93/dfs/lib/tkesrv 2018-10-25T15:13:09,093 DEBUG [00000004] Cradle :sas - [1]: -set 2018-10-25T15:13:09,093 DEBUG [00000004] Cradle :sas - [2]: TKPATH 2018-10-25T15:13:09,093 DEBUG [00000004] Cradle :sas - [3]: /sas/SAS93/dfs/lib 2018-10-25T15:13:09,093 DEBUG [00000004] Cradle :sas - [4]: -config 2018-10-25T15:13:09,093 DEBUG [00000004] Cradle :sas - [5]: /sas/sasconfig/Lev1/FrameworkServer/dffedsvrcfg/dfs_serv.xml 2018-10-25T15:13:09,093 DEBUG [00000004] Cradle :sas - [6]: -logconfigloc 2018-10-25T15:13:09,093 DEBUG [00000004] Cradle :sas - [7]: /sas/sasconfig/Lev1/FrameworkServer/dffedsvrcfg/dfs_log.xml 2018-10-25T15:13:09,095 DEBUG [00000004] IOM :sas - IOM LOGIC tkiomsvc starting 2018-10-25T15:13:09,096 DEBUG [00000004] Logging :sas - Loading the tk4aiomc support extension (1.0.20110502). 2018-10-25T15:13:09,096 DEBUG [00000004] Logging.Appender.IOMCallContext :sas - Creating IOMCallContextAppender IOM Call Appender 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=NOSECURITY not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=ANONYMOUSLOGINPOLICY not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=OBJSPAWN not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=MULTIUSER not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=SHAREDINSTANCE not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=LAZYDISCONNECTION not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=V8ERRORTEXT not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=GRID not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=NOBSTRS not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=BSTRS not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=PROTOCOL value=bridge 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=CLASSFACTORY not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=CLSID value=E803E04B-AAF0-4C74-86A6-F7008AA702DC 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=THREADSMIN not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=TMIN not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=THREADSMAX not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=TMAX not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=THREADSMORE not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=TMORE not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=THREADSTIMEOUT not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=TTIMEOUT not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=THREADSSTACKSIZE not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=TSTACKSIZE not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=SASLANGRUNAS not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=APPLEVEL not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=IOMLEVEL not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=JNLTRACE not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=PELEVEL not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=JNLSTRMAX not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=JNLARRELM not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=JNLANYARRELM not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=JNLLINEMAX not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=VALIDATE not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=TIMEOUTSECONDS not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=FROMTK not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=FROMMVA not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=CLASSDEFINITIONS not found 2018-10-25T15:13:09,097 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=CD not found 2018-10-25T15:13:09,104 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=DNSNAME not found 2018-10-25T15:13:09,105 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=LOG not found 2018-10-25T15:13:09,105 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=LOGFILE not found 2018-10-25T15:13:09,105 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=PROTOCOL value=bridge 2018-10-25T15:13:09,105 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=SERVER not found 2018-10-25T15:13:09,105 DEBUG [00000004] IOM :sas - IOM CALL svcGetOption(): opt=SERVERCOMPONENT not found 2018-10-25T15:13:09,105 DEBUG [00000008] IOM :sas - IOM CALL svcGetOption(): opt=CLASSFACTORY not found 2018-10-25T15:13:09,105 DEBUG [00000008] IOM :sas - IOM CALL svcGetOption(): opt=CLSID value=E803E04B-AAF0-4C74-86A6-F7008AA702DC 2018-10-25T15:13:09,105 DEBUG [00000008] IOM :sas - IOM CALL svcGetOption(): opt=OBJSPAWN not found 2018-10-25T15:13:09,105 DEBUG [00000008] IOM :sas - IOM CALL svcGetOption(): opt=CRADLE no value 2018-10-25T15:13:09,106 DEBUG [00000008] App.Server :sas - IOM load component metadata - Server: majorVersion=1, minorVersion=0, majorUUID=e803e04b-aaf0-4c74-86a6-f7008aa702dc, minorUUID=e803e04b-aaf0-4c74-86a6-f7008aa702dc 2018-10-25T15:13:09,106 DEBUG [00000008] IOM :sas - IOM CALL svcGetOption(): opt=SPAWNED not found 2018-10-25T15:13:09,106 DEBUG [00000008] Perf.ARM.IOM.Server :sas - START Perf.ARM.IOM.Server 0 0 2018-10-25T15:13:09,106 DEBUG [00000008] App.Server :sas - IOM LOGIC ENTRY {class:7f59af70f1c0}->ServerClassNew() 2018-10-25T15:13:09,106 DEBUG [00000008] IOM :sas - IOM CALL svcGetOption(): opt=SPAWNED not found 2018-10-25T15:13:09,106 DEBUG [00000008] IOM :sas - IOM CALL svcGetOption(): opt=SERVER not found 2018-10-25T15:13:09,106 DEBUG [00000008] IOM :sas - IOM CALL svcGetOption(): opt=SERVERCOMPONENT not found 2018-10-25T15:13:09,106 DEBUG [00000008] IOM :sas - IOM CALL svcGetOption(): opt=PORT value=22031 2018-10-25T15:13:09,106 DEBUG [00000008] IOM :sas - IOM CALL svcGetOption(): opt=APPLEVEL not found 2018-10-25T15:13:09,107 DEBUG [00000008] IOM :sas - IOM CALL svcGetOption(): opt=NOSECURITY not found 2018-10-25T15:13:09,108 WARN [00000008] DataFlux.Licensing :sas - License checkout failed for feature 'Domestic encryption support' due to the following: The feature is not licensed. 2018-10-25T15:13:09,108 WARN [00000008] App.Program :sas - Unable to decode SAS003 password due to missing encryption algorithm. 2018-10-25T15:13:09,108 ERROR [00000008] DataFlux.Licensing :sas - License checkout failed for feature 'Domestic encryption support' due to the following: The feature is not licensed. 2018-10-25T15:13:09,109 DEBUG [00000008] Audit.Table.Connection :sas - Input connection - (CATALOG=FB;DRIVER=TRAN;DATABASE={/sas/sasconfig/Lev1/FrameworkServer/dffedsvrcfg/syscat.tdb}) ... View more

Thanks, but this is not exactly that. The note for the most part describes what logs are needed for the analysis of technical support. ... View more