cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
SAS_LuisBolivar
‎10-25-2023
  • 61 Posts
  • 9 Likes Given
  • 2 Solutions
  • 8 Likes Received

Problem validating WorkSpace Server.

by Quartz | Level 8 in Administration and Deployment
‎10-21-2023 09:15 PM
‎10-21-2023 09:15 PM
Problem validating WorkSpace Server.   I'm having trouble validating the WorkSpace Server. I don't see any type of error in the ObjectSpawner log.   But it seems strange to me that connection 9 that is trying to start selects a port other than 8591.   2023-10-20T19:38:58,656 INFO [00000031] :sas - Reserved IPv6 port 8581 for administrator listen (connection 2). 2023-10-20T19:38:58,656 INFO [00000031] :sas - Reserved IPv6 port 8451 for server listen (connection 3). 2023-10-20T19:38:58,657 INFO [00000031] :sas - Reserved IPv6 port 8701 for server listen (connection 4). 2023-10-20T19:38:58,691 INFO [00000031] :sas - Reserved IPv6 port 8601 for server listen (connection 5). 2023-10-20T19:38:58,691 INFO [00000031] :sas - Reserved IPv6 port 8611 for server listen (connection 6). 2023-10-20T19:38:58,691 INFO [00000031] :sas - Reserved IPv6 port 8621 for server listen (connection 7). 2023-10-20T19:38:58,691 INFO [00000031] :sas - Reserved IPv6 port 8631 for server listen (connection 8). 2023-10-20T19:38:58,704 INFO [00000031] :sas - Reserved IPv6 port 38879 for launched server connect back listen (connection 9). 2023-10-20T19:38:58,704 INFO [00000031] :sas - Activated listen on IPv6 port 38879 (connection 9).   Have you ever had a similar problem?   Thank you. ... View more

Re: Format Cobol

by Quartz | Level 8 in SAS Programming
‎12-23-2022 03:52 PM
‎12-23-2022 03:52 PM
Greetings. If it is the Cobol programming language. There is a sas code that creates a .dat file, this program comes from SAS 9.3 (AIX) and the client migrated to SAS 9.4 (Linux). On AIX the value shown in the .dat file is 4=▒ On linux the value displayed in the .dat file is 4=Ç Simulate your sas program: 27 28 data _null_; 29 x = '4=▒' ; 30 put x= $quote. / x= $hex.; 31 run; x="4=▒" x=343DE29692 Thank ... View more

Format Cobol

by Quartz | Level 8 in SAS Programming
‎12-22-2022 07:40 PM
‎12-22-2022 07:40 PM
Good evening community.   I have a program on 9.3 (AIX) that generates the following value for COBOL 4=▒ when applying the IB4 format. At value date 20200903.   The same program in SAS 9.4 (LINUX) generates the following value 4=Ç   What format can I apply to obtain the same value (4=▒)?.   Thank. ... View more

Adding Custom-Developed WAR to SAS Portlets

by Quartz | Level 8 in Administration and Deployment
‎11-02-2022 04:33 PM
‎11-02-2022 04:33 PM
Greetings community. I have the following situation. I need to deploy to SAS 9.4 a WAR that was up and running on SAS 9.3. I would like to know if you have had experience with this type of activity and if you can tell me the steps. Thanks. ... View more

Re: ODBC DataFlux Connection Error, Mondash

by Quartz | Level 8 in Administration and Deployment
‎10-30-2022 04:33 PM
‎10-30-2022 04:33 PM
Greetings.   In the end I managed to solve applying the following steps:   Delete the connection established by the modash macro. Add Mondash odbc connection to DataFlux. In the echo transformation, add the variables required by the process, such as DB_DSN, DB_SCHEMA, etc. The SQL process that deletes the data from the current repository was changed to a process that executes SAS code. The other processes run without any adaptation.   Thanks. ... View more

Re: Error create table with data step in SQL Server

by Quartz | Level 8 in SAS Programming
‎10-29-2022 12:47 PM
‎10-29-2022 12:47 PM
The Result: CREATE TABLE "##WYQXD98" ("ETLS_KEY" NOT NULL ,"ETLS_CLSDATE" ) ... View more

Re: Error create table with data step in SQL Server

by Quartz | Level 8 in SAS Programming
‎10-29-2022 08:42 AM
‎10-29-2022 08:42 AM
Good morning.   The SCD2 transformation generates a proc dataset code that deletes the table before creating it, this process does not fail.   MPRINT(ETLS_SCDLOADER): LIBNAME etlstmp SQLSVR READBUFF=32767 INSERTBUFF=32767 Datasrc=XXXXXX CONNECTION=GLOBAL SCHEMA=dbo USER=xxxx PASSWORD="XXXXXXXXXXX" DBMSTEMP=YES; NOTE: Libref ETLSTMP was successfully assigned as follows: Engine: SQLSVR Physical Name: XXXXXXXXXXXXXX NOTE: Dropping table ... MPRINT(ETLS_PUSHTODBMS): proc datasets lib = etlstmp nolist nowarn memtype = (data view); MPRINT(ETLS_PUSHTODBMS): delete WP9SZD4; MPRINT(ETLS_PUSHTODBMS): quit; NOTE: PROCEDURE DATASETS used (Total process time): 18 The SAS System 19:45 Friday, October 28, 2022 real time 0.05 seconds cpu time 0.00 seconds MPRINT(ETLS_PUSHTODBMS): ; MPRINT(ETLS_PUSHTODBMS): data etlstmp.WP9SZD4 (dbnull = ( ETLS_KEY = NO ETLS_CLSDATE = YES)); MPRINT(ETLS_PUSHTODBMS): attrib ETLS_KEY length = 8; MPRINT(ETLS_PUSHTODBMS): attrib ETLS_CLSDATE length = 8 format = DATETIME22.3 informat = DATETIME22.3 label = 'VALID_TO_DTTM'; MPRINT(ETLS_PUSHTODBMS): call missing(of _all_); MPRINT(ETLS_PUSHTODBMS): stop; MPRINT(ETLS_PUSHTODBMS): run; NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. ERROR: Error attempting to CREATE a DBMS table. . NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. NOTE: Due to ERROR(s) above, SAS set option OBS=0, enabling syntax check mode. This prevents execution of subsequent data modification statements. WARNING: The data set ETLSTMP.WP9SZD4 may be incomplete. When this step was stopped there were 0 observations and 2 variables. ERROR: ROLLBACK issued due to errors for data set ETLSTMP.WP9SZD4.DATA. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds ... View more

Re: Error create table with data step in SQL Server

by Quartz | Level 8 in SAS Programming
‎10-28-2022 11:35 PM
‎10-28-2022 11:35 PM
Execution log sample: MPRINT(ETLS_PUSHTODBMS): ; MPRINT(ETLS_PUSHTODBMS): data etlstmp.WP9SZD4 (dbnull = ( ETLS_KEY = NO ETLS_CLSDATE = YES)); MPRINT(ETLS_PUSHTODBMS): attrib ETLS_KEY length = 8; MPRINT(ETLS_PUSHTODBMS): attrib ETLS_CLSDATE length = 8 format = DATETIME22.3 informat = DATETIME22.3 label = 'VALID_TO_DTTM'; MPRINT(ETLS_PUSHTODBMS): call missing(of _all_); MPRINT(ETLS_PUSHTODBMS): stop; MPRINT(ETLS_PUSHTODBMS): run; NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. ERROR: Error attempting to CREATE a DBMS table. . NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. NOTE: Due to ERROR(s) above, SAS set option OBS=0, enabling syntax check mode. This prevents execution of subsequent data modification statements. WARNING: The data set ETLSTMP.WP9SZD4 may be incomplete. When this step was stopped there were 0 observations and 2 variables. ERROR: ROLLBACK issued due to errors for data set ETLSTMP.WP9SZD4.DATA. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds ... View more

Error create table with data step in SQL Server

by Quartz | Level 8 in SAS Programming
‎10-28-2022 11:25 PM
‎10-28-2022 11:25 PM
Error create table with data step in SQL Server.   ERROR: Error attempting to CREATE a DBMS table. .   It does not indicate an error description and when executing via pass-through it does not fail, but the SCD 2 transformation generates the tables with data passing.   Thanks. ... View more

ODBC DataFlux Connection Error, Mondash

by Quartz | Level 8 in Administration and Deployment
‎10-27-2022 09:54 AM
‎10-27-2022 09:54 AM
Good morning colleagues. I am presenting the following situation:   For performance and policy reasons we need to change the Mondash schema database engine, by default it is PostgreSQL and we must change it to ORACLE.   The first thing we must adapt is the connection from the client and for that we make the following modifications:   Inside the mondash.cfg file we update the connection string   Using the DataFlux 32-bit Oracle Wire Protocol driver as follows:   MONDASH/DSN=Driver=DataFlux 32-bit Oracle Wire Protocol;DFXDOMAIN=xxxxx_ _Auth;DB=oracle;Host=xxxxxxx.com;Port=1521;DFXTYPE=ODBC   Result: [DataFlux][ODBC Oracle Wire Protocol driver]Insufficient information to connect to the data source.   Using an Oracle driver installed on the client machine:   MONDASH/DSN=Driver={Oracle in instantclient_12_2};DFXDOMAIN=xxxxx_ _Auth;DB=oracle;Host=xxxxxxx.com;Port=1521;DFXTYPE=ODBC   Result: [Oracle][ODBC][Ora]ORA-12560: TNS:protocol adapter error   Does anyone have experience with these types of errors?   Thanks. ... View more

Error running in Data Integration Studio: Data Job and applying standa...

by Quartz | Level 8 in SAS Programming
‎10-14-2022 09:37 PM
‎10-14-2022 09:37 PM
Goodnight.   I am having the following problem when executing a data job from a Data Integration job: ERROR: Architect job XXXXXXXX.ddf failed (Timeout). ERROR: Job execution terminated. ERROR: DMSRVBATCHJOB function failed with return code ERROR: Execution terminated by an ABORT statement at line 49 column 10.   When validating the Log from Data Flux Management Studio, it indicates that the data job was executed correctly.     Additionally, I am presenting the following alert, a transformation of applying standardized schema:   Apply Lookup Standardization Line 2,755: WARNING: Scheme type BFD is deprecated. Replace with scheme type QKB.   Can you help me solve these problems?   Thanks. ... View more

Error connecting DataFlux Data Management Studio to SAS Metadata Serve...

by Quartz | Level 8 in Administration and Deployment
‎09-25-2022 05:00 PM
‎09-25-2022 05:00 PM
Hello Community.   I need your support with the following error:   ERROR DF.DMStudio.AuthenticationServiceClient.AuthenticationServiceClient - Failed to authenticate user 'sasadm' (ERROR: The client has connected to a SAS Metadata Server (v1.0) when it intended to connect to a DataFlux Authentication Server. ).   Which is generated when connecting DataFlux Data Management Studio to SAS Metadata Server.   Thanks. ... View more

Job de SAS Data Integration Studio - Error fetching Library

by Quartz | Level 8 in SAS Data Management
‎06-20-2022 02:02 PM
‎06-20-2022 02:02 PM
Good afternoon dear community. I need your support to solve the following problem   I have several SAS Data Integration Studio Jobs that read data from Oracle.   When executing it does not generate an error, but when trying to open the table resulting from the EXTRACT it tells me the following:     If I try the execution again without closing the etl it works.   Only when opening it and running it the first time it fails.   Thanks. ... View more

Re: SAS Web - Error reading status line from remote server

by Quartz | Level 8 in Administration and Deployment
‎06-20-2022 09:11 AM
‎06-20-2022 09:11 AM
Hello. To solve the problem, follow the steps indicated in the following note:   https://support.sas.com/kb/64/488.html   Just apply solution #1.   Thanks. ... View more

Re: Logical Pooled Workspace Server and Logical Stored Process Server ...

by Quartz | Level 8 in Administration and Deployment
‎03-28-2022 04:31 PM
‎03-28-2022 04:31 PM
Good afternoon. If it seems to me that it could be that, at the operating system level, how do I validate the DNS? Thanks. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-25-2023 10:43 PM
Likes given to
Likes from
Quick links