Hi All ,    Recently we have applied new licenses for ALL SAS application and we have cross checked the same using proc setinit ;run;    But still we want to check the same from the SAS Financial Management tool also , Kindly help me is there any way to do same.   Regards,  Mahesh      ... View more

hi all,       i want to update the old record in scd type 2 history using proc sql  and how can i do it ?   below is the table screen shot :-    select PARTY_KEY,PARTY_number,CHANGE_END_DATE,CHANGE_begin_DATE,SOL_id from AMLCORE.fsc_party_dim_solnull where party_number='00077886' ;   Output :-  PARTY_KEY PARTY_NUMBER CHANGE_END_DATE CHANGE_BEGIN_DATE SOL_ID 14625 00077886 01/01/5999 00:00:00 01/16/2019 00:00:00 NULL 1267882 00077886 01/16/2019 00:00:00 02/13/2014 00:00:00 012   I want to update the SOL_ID from old record to new record .Please help me .   i have tried to run below query but it is failing :-    update AMLCORE.fsc_party_dim_solnull new set sol_id= (select sol_id from AMLCORE.fsc_party_dim_solnull old where old.party_number=new.party_number and old.segment_id=new.segment_id and CHANGE_END_DATE<>'01-jan-5999' ) where CHANGE_END_DATE='01-jan-5999' and sol_id is null and CHANGE_BEGIN_DATE >'01-jan-2019' ; ... View more

Hi All,    I want to create manual Risk Assessment using SAS AML UI but instead one by one i want to load it in bulk. Is it possible to in using SAS DI job ? I am able to add the in FSK_RISK_ASSESSMENT table . What are all other tables needs to be updated/loaded.   @manishiiita @Patrick @Alzak12  Please help me in this. ... View more

Hi All,    What is the use of the parameter tab in SAS DI Job ? PFB is screenshot of the same. What is use of Prompt , will it used for sending some variable value while running the DI job?   ... View more

Hi All,      I have created the SAS DI job which will the data from flat file to SAS data set () and then I am applying SCD type 2 on this data set to load it to oracle table PFB is screenshot of the Job :-    Data is coming till fsk_risk_assessment_work data set but same is not loading to Oracle table and Giving below warning :-   Line 2: WARNING: Variable PROPOSED_RISK_CLASSIFICATION not appended because of type mismatch   when i checked type of PROPOSED_RISK_CLASSIFICATION  in SAS data set fsk_risk_assessment_work is character  and in fsk_risk_assessment (oracle table ) it is numeric and i have used INPUT(PROPOSED_RISK_CLASSIFICATION,$8.) in mapping also. Please help me in the same. ... View more

Hi All,    recently I have created one DI job which is having the table loader in the job and loading the data into the SAS data set but it is failing  with below mentioned warning :-    warning :-   Table Loader  Line 520: WARNING: Add/Update failed for data set SASWORK.FSK_RISK_ASSESSMENT_WORK because data value(s) do not comply with integrity constraint _NM0001_. (Occurred 73 times.)   Due to the same warning , data is not getting loaded into the SASWORK.FSK_RISK_ASSESSMENT_WORK data set. Can somebody help on the same ? Many thanks in advance .   ... View more

  Hi All,    I am trying stop the WebSphere server(SASServer8 )  using was admin console and getting below mentioned error :- Error :- [1/20/19 18:57:19:312 AST] 00000028 AdminHelper A ADMN1021I: An attempt is made to stop the SASServer8 server. [1/20/19 18:57:24:453 AST] 00000004 ApplicationMg A WSVR0217I: Stopping application: ibmasyncrsp [1/20/19 18:58:08:863 AST] 0000002c AlarmThreadMo W UTLS0008W: The return of alarm thread "Non-deferrable Alarm : 0" (00000004) to the alarm thread pool has been delayed for 49440 milliseconds. This may be preventing normal alarm function within the application server. The alarm listener stack trace is as follows: at com.ibm.ws.webcontainer.component.WebContainerImpl.stop(WebContainerImpl.java:679) at com.ibm.ws.runtime.component.ApplicationMgrImpl.stop(ApplicationMgrImpl.java:1151) at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStop(DeployedApplicationImpl.java:1324) at com.ibm.ws.runtime.component.DeployedModuleImpl.stop(DeployedModuleImpl.java:646) at com.ibm.ws.runtime.component.DeployedApplicationImpl.stop(DeployedApplicationImpl.java:1098) at com.ibm.ws.runtime.component.ApplicationMgrImpl.stopApplication(ApplicationMgrImpl.java:922) at com.ibm.ws.runtime.component.ApplicationMgrImpl.stop(ApplicationMgrImpl.java:875) at com.ibm.ws.runtime.component.ContainerHelper.stopComponent(ContainerHelper.java:475) at com.ibm.ws.runtime.component.ContainerHelper.stopComponents(ContainerHelper.java:459) at com.ibm.ws.runtime.component.ContainerImpl.stopComponents(ContainerImpl.java:650) at com.ibm.ws.runtime.component.ContainerImpl.stop(ContainerImpl.java:638) at com.ibm.ws.runtime.component.ApplicationServerImpl.stop(ApplicationServerImpl.java:257) at com.ibm.ws.runtime.component.ContainerHelper.stopComponent(ContainerHelper.java:475) at com.ibm.ws.runtime.component.ContainerHelper.stopComponents(ContainerHelper.java:459) at com.ibm.ws.runtime.component.ContainerImpl.stopComponents(ContainerImpl.java:650) at com.ibm.ws.runtime.component.ContainerImpl.stop(ContainerImpl.java:638) at com.ibm.ws.runtime.component.ServerImpl.stop(ServerImpl.java:615) at com.ibm.ws.runtime.component.ServerCollaborator$ShutdownHook$1.run(ServerCollaborator.java:738) at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:5305) at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:5483) at com.ibm.ws.runtime.component.ServerCollaborator$ShutdownHook.run(ServerCollaborator.java:728) at com.ibm.ws.runtime.component.ServerCollaborator$StopAction.alarm(ServerCollaborator.java:692) at com.ibm.ejs.util.am._Alarm.run(_Alarm.java:133) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1656).   had any one faced this issue before and found the solution ? Is there any workaround for it?   Why this error is coming ? Will there be problem from SAS Application side or no ?  Will SAS support team help in it ?       ... View more

Hi All,   Happy New year to all .   we have developed one SAS DI job which is having user written code in the job. This user written code will load the data from Dow jones file to the Oracle data base and job is running fine and loading the data too. But it is having below mentioned WARNING in the log tab in SAS DI.   WARNING :-   ************** End:    SQL*Loader Log File ************** WARNING: All or some rows were rejected/discarded!(or possibly there were other errors like Index maintenance errors) **********************************************************************  Please look in SQL*Loader log for the load results.  SQL*Loader Log location(only if BL_DELETE_FILES=NO is set): -- BL_FSC_ENTITY_WATCH_LIST_DIM_0.log --  Note:In Client/Server environment,the Log File is located on the Server. The log is also echoed in the Server SAS log file. ********************************************************************** NOTE: PROCEDURE APPEND used (Total process time):   so I have few questions about the warning as below :- Where is the BL_FSC_ENTITY_WATCH_LIST_DIM_0.log log file located  ? is it in SAS APPLICATION server or oracle server or in my desktop ? What is the  BL_DELETE_FILES=NO is set ? Do I need to set this options before running the SAS DI JOB ?   ... View more