Pages

Tuesday, October 18, 2011

Cisco AnyConnect Client Download

Hi

You can find at this URL all the Cisco AnyConnect clients

http://www.tycoon.mxm.cx/

EBI -=- Context Point possible variables

Here is the list of context points available in EXTOL EBI 2.5.

You can get the value of the variable by lauching the task Context Point - Get Value
  • env.var.Acknowledgement_Id

  • env.var.Address_for_Reverse_Routing

  • env.var.Application_Password

  • env.var.Application_Receiver_Id

  • env.var.Application_Receiver_Id_Qualifier

  • env.var.Application_Reference

  • env.var.Application_Sender_Id

  • env.var.Application_Sender_Id_Qualifier

  • env.var.Authorization_Information

  • env.var.Authorization_Qualifier

  • env.var.Code_List_Dir_Version

  • env.var.Collaboration_Profile_Id

  • env.var.Communications_Agreement

  • env.var.Decimal_Notation

  • env.var.Function_Group_Message_Count

  • env.var.Functional_Group_Code

  • env.var.Functional_Group_Control_Number

  • env.var.Functional_Group_Date

  • env.var.Functional_Group_Responsible_Agency_Code

  • env.var.Functional_Group_Time

  • env.var.Functional_Group_Version_Release_Industry_Code

  • env.var.Industry_Group

  • env.var.Industry_Id_Code

  • env.var.Interchange_Acknowedgement_Requested

  • env.var.Interchange_Control_Number

  • env.var.Interchange_Date

  • env.var.Interchange_Syntax_Id

  • env.var.Interchange_Time

  • env.var.Interchange_Version

  • env.var.Is_Reprocess

  • env.var.Log_of_Application_Batch_Id

  • env.var.Log_of_Collaboration_Id

  • env.var.Log_of_Connection_Id

  • env.var.Log_of_Envelope_Assembly_Id

  • env.var.Log_of_Group_Id

  • env.var.Log_of_Interchange_Id

  • env.var.Log_of_Message_Id

  • env.var.Log_of_Work_Id

  • env.var.Message_Control_Number

  • env.var.Message_Id

  • env.var.Message_Segment_Count

  • env.var.Message_Type_Sub_Id

  • env.var.Priority_Code

  • env.var.Process_Id

  • env.var.Receiver_Id

  • env.var.Receiver_Id_Qualifier

  • env.var.Release_Indicator_Character

  • env.var.Repetition_Seperator

  • env.var.Routing_Address

  • env.var.Security_Information

  • env.var.Security_Qualifier

  • env.var.Sender_Id

  • env.var.Sender_Id_Qualifier

  • env.var.Source_Data_Id

  • env.var.Source_Element_Delimiter

  • env.var.Source_Segment_Delimiter

  • env.var.Source_Sub-element_Delimiter

  • env.var.Standards_Class

  • env.var.Target_Element_Delimiter

  • env.var.Target_Segment_Delimiter

  • env.var.Target_Sub-element_Delimiter

  • env.var.Test_Production

  • env.var.User_Reference_1

  • env.var.User_Reference_2

  • env.var.User_Reference_3

  • env.var.User_Reference_4

  • env.var.User_Reference_5

  • env.var.Version_Release

  • glb.con.EDI_COMPOSITE_ELEMENT

  • glb.con.EDI_MESSAGE_DICTIONARY

  • glb.con.EDI_SEGMENT_DICTIONARY

  • glb.con.EDI_SIMPLE_ELEMENT

  • glb.con.hh:MM:ss

  • glb.var.Conditional_Expression_Result_2

  • glb.var.Instance_Counter_1

  • glb.var.Instance_Counter_2

  • glb.var.String_Result_1

  • glb.var.String_Result_2

EBI -=- Sending an EDI file (ISA) by email

Problem


Sending the whole interchange (ISA) of a transaction by email with EBI 2.5

Solution


To receive the entire interchange in an email message, you must pass the Source_Input_Data_Fragment script parameter as the attachment for the send email task in your Collaboration Business Process. This would allow you to receive the entire document as an email attachment rather than as the message content. We would like to inform you that this current solution may be altered to work differently in a future version release of EBI, but you can currently do this in EBI 2.5.

Friday, October 7, 2011

EXTOL & Oracle Express -=- Strange Database Error ORA-12519

Hi!

Today I had a mysterious error when using EXTOL Business Integrator 2.5 I have a business process in which I have some objects that do a lookup into an Oracle Express 11g database. I'm facing to a strange behaviour. Some times, my business processe is successful and some times not.

When I go into the Log Auditor, Application and the Process tab, I'm getting this following error:

[ERROR] Transformation ended in error, please refer to the information on the Translation Message Tab.
When I look on the Translation Messages tab, Step #2: Execute Transformation - Single Output, I'm getting this error:

Message ID: 273
Primary: SQL Access error: XREF_TradingPartner_Location: The connection to DriverID: a8ece772aeaf4130be919d5e9698ebca DatabaseURL: jdbc:oracle:thin:@localhost:1521:XE is null.
Secondary:
Category: General
Type: Hard_Error
Process ID: 859
Issued by: class com.extol.transformationrules.SQLAction
Msg file: messages.emf
Issued on: Friday October 7, 2011 10:45:00.746 AM EDT

In order to have more information on the issue, I've looked into the server log file at
EBI_INSTALLATION\jboss\server\ebi\log\server.full

I've found the following stacktrace

2011-10-07 10:22:52,402 INFO [STDOUT] Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
localhost:1521:XE

According to Oracle, here's the definition of the error (http://ora-12519.ora-code.com/)

ORA-12519:

TNS:no appropriate service handler found
Cause: The listener could not find any available service handlers that are appropriate for the client connection.
Action: Run "lsnrctl services" to ensure that the instance(s) have registered with the listener, and are accepting connections.


At this point, it looks like Oracle Express is not accepting enough connexions. When EBI try to do some lookups in the database some times, Oracle Express ran out of available connexions.

We will verify this assumption


Step #1 - Verifying the configuration of Oracle Express

- Open Windows Command Manager and type sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Ven. Oct. 7 11:47:30 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter user-name: SYSTEM
Enter password:

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

SQL> show parameter processes

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 4
log_archive_max_processes integer 4
processes integer 40


We see that the limit of concurrent processes in 40

Verify how many concurrent processes the system has actually
SQL> select count(*) from v$process;

COUNT(*)
----------
29


The hypothesis is valid.


Step #2 - Increase the value up to 200 processes

In SQLPlus,

SQL> ALTER SYSTEM SET processes=200 scope=spfile;

System altered.


Step #3 - Restart the server

You can verify that setting has been applied by doing a "show parameter processs" (see step #1)

Step #4 - Relaunch EBI's Business Processes

You can now relaunch the business processes many times in EBI to verify that the problem is solved.