Switch to standard view 
  Sybase logo
 
 
 



Topic

Page

1. Accessing current release bulletin information

2. Product summary

3. ECMap

4. EC Gateway

5. ECRTP

6. ECRTP/TP

7. Adapter for EDI

8. Technical support

9. Other sources of information

1. Accessing current release bulletin information

A more recent version of this release bulletin may be available on the Web. To check for critical product or document information added after the release of the product CD, use the Sybase® Technical Library Product Manuals Web site.

Accessing release bulletins at the Technical Library Product Manuals Web site

  1. Go to Product Manuals.

  2. Follow the links to the appropriate Sybase product.

  3. Select the Release Bulletins link.

  4. Select the Sybase product version from the Release Bulletins list.

  5. From the list of individual documents, select the link to the release bulletin for your platform. You can either download the PDF version or browse the document online.


2. Product summary

Sybase EDI Server includes a suite of powerful components that meet the needs of any organization processing EDI: the ECMap™ Development Workbench, ECRTP™ runtime environment with Trading Partner management capabilities, and EC Gateway™ to support message management, VAN connectivity, and operations management.

Sybase distributes EDI Server 4.2 as a product bundle, which includes:

2.1 Operating systems

2.2 Database support

2.3 Installation instructions

For details on system requirements and platform information, see the EDI Products 4.2 Installation and Configuration Guide.

2.4 Documentation

This table identifies documentation common to all EDI products. See individual product sections for specific product documentation.

Title

Description

Location

EDI Products 4.2 Release Bulletin

Summarizes key product features, installation steps, and known issues relating to this release.

edi42rb.pdf on Getting Started EDI Server 4.2 Product CD

EDI Products 4.2 New Features Guide

Identifies changes and updates to the EDI 4.2 product suite.

edi42nfg.pdf in \doc folder of your install directory

EDI Products 4.2 Installation and Configuration Guide

Includes procedures required to install, configure, and run the EDI products.

edi42ig.pdf in \doc folder of your install directory



General documentation note

Sybase recently acquired the technology and interests of New Era of Networks®. While we are currently integrating all EDI products into the Sybase product family, some documentation may still refer to New Era of Networks. We plan to complete the transition as soon as possible and are pleased to offer Sybase's full line of products, services, and solutions.


3. ECMap

ECMap includes mapping tools that allow you to develop complex maps for processing EDI transactions. ECMap supports sequential and delimited file formats and standards, which include ANSI X12, UN/EDIFACT, NCPDP, and HL7.

The EDI Server 4.2 product bundle for ECMap includes ECMap (SV) and ECMap Network Client (2 seats, 1 cold backup).

3.1 Documentation

This table identifies documentation specific to ECMap 4.2.

Title

Description

Location

EC Map Getting Started Guide

Includes a series of tutorials that walk you through the creation of particular maps and record definitions needed by ECMap.

ecm42gs.pdf in \doc folder of your install directory.

EC Map Reference Guide

Includes technical information and topics relevant to understanding and using ECMap, including new product features.

ecm42ref.pdf in \doc folder of your install directory.

EC Map User’s Guide

Provides step-by-step instructions that you need to work with ECMap.

ecm42ug.pdf in \doc folder of your install directory.

ECMap Installation Keys

Includes the product key you need to install ECMap components. There are separate key documents for:

  • ECMap - SV

  • ECMap - AV

  • ECMap Network Client

Print only

3.2 CRs resolved with this release

CR

Description

274529

Problem: Exact behavior of the Link Only feature is not documented

Resolution: Under Record Type on the Required tab on the map flow property sheet, the Link Only option indicates that this level is linked to the Master level or a repeating parent level. The link level can only be reached after a break occurs (the key value changes or the end-of-file is reached). When a break occurs, the flow returns to the Master (or repeating parent) level, and proceeds to the link level. If the break was an end of file the processing ends, otherwise the flow returns to the link level parent.

275850

Problem: ECMap SQL_RETURN documentation incorrect

Resolution: The SQL_RETURN system variable is used to determine if the last Fetch command in ECMap returned a result set. The SQL_RETURN system variable can be used in an IF/THEN(/ELSE) command to determine if a result set has been returned. Check the SQL_RETURN value against the “End of File” option found in ECMap. See Chapter 19 “Working with System Variables” in the ECMap 4.2 Reference Guide for additional information.

296329

Problem: ECMAP Record properties - special characters doesn't have a drop down list

Resolution: ECMap now includes a drop down list for special characters. If you choose SP CH an additional field displays with an up arrow from which the user can select a special character. See the ECMap 4.2 Reference Guide for additional information.

319511

Problem: Overwriting USER_OUT_FILENAME variable documentation

Resolution: Previous versions of the documentation incorrectly state that the USER_OUT_FILENAME variable can be overwritten. ECMap uses this variable for information purposes. When a write of some kind is done, the file name is recorded in this variable and cannot be overwritten. See “Working with System Variables” in the ECMap User's Guide for additional information.

347788

Problem: A mechanism to merge/import cross-reference table updates from map to map is required. Resolution: A new utility has been added to the GUI that will allow the user to import cross-reference tables from one map to another.

347793

Problem: There is no easy way to import multiple rules from one map to another.

Resolution: A new method for importing rules from map to map has been added. This will allow the user to select multiple rules to import at once. This is in place of the old method, which allowed one rule at a time to be imported.

356006

Problem: No documentation on limits of the Today’s Date +/- n Days attribute

Resolution: You use the Today’s Date +/- n Days attribute if the memory variable is a calculated date based on today’s date. This date is derived from the system clock. If you select this attribute, an additional text box displays following Today’s Date +/- n Days. Enter the value for the number of days to be added to or subtracted from today’s date. The limit for the number of days is between -999 to +999 (-999 to 9999 if you do not include the plus sign). See “Working with Memory Variables” in the ECMap User's Guide for additional information.

356923

Problem: There are no documents supplied with EC Map that show how to create NCPDP maps from scratch and what features fit within the specification. Also nothing on NCPDP Compliance maps. Customer would like full documentation on NCPDP functionality along with step by step instructions for creating an NCPDP map from scratch.

357958

Problem: Map Each Loop the Same Way was not working.

Resolution: Fixed.

359466

Problem: The outbound split file routine was not writing out the generated keys.

Resolution: Corrected the number of characters that needed to be written out for the generated key record.

360229

Problem: ECRTP 4.0.3 -mm I/O Redirect of temp files resulted in a command on a rule being skipped, which results in the same data being acted on twice. This does not happen when the temp files are run to disk.

Resolution: Fixed.

4. EC Gateway

EC Gateway is an enterprise-wide message management software, designed specifically to support inter- and intra-company electronic messages. EC Gateway has three main functions: process management, communications, and scheduling, and includes extensive reporting facilities, a trading partner interface, a single ODBC-compliant log database, and archive/restore functions.

The EDI Server 4.2 product bundle for EC Gateway includes:

4.1 Documentation

This table identifies documentation specific to EC Gateway 4.2.

Title

Description

Location

EC Gateway Reference Guide

Includes essential technical information you need to use EC Gateway to route, process, and manage electronic messages.



Note

There are separate reference guides for Unix and Windows.


ecgunix.pdf and ecgwin.pdfin \doc folder of your install directory.

EC Gateway Operations Viewer Reference Guide

Provides technical information and topics that help you understand and use EC Gateway Operations Viewer to monitor activities from a remote location.

ecgops.pdfin \doc folder of your install directory.

EC Gateway Remote Reference Guide

Tells you how to extend the capabilities of EC Gateway to process scripts on remote computers without the need for multiple EC Gateway systems.

ecgrem.pdfin \doc folder of your install directory.

EC Gateway Installation Keys

Includes the product key you need to install EC Gateway components. There are separate key documents for:

  • EC Gateway for Windows

  • EC Gateway for HP - UX

  • EC Gateway for AIX

  • EC Gateway for Solaris

  • EC Gateway Operations Viewer

  • EC Gateway Remote for Windows

  • EC Gateway Remote for HP - UX

  • EC Gateway Remote for AIX

  • EC Gateway Remote for Solaris

Print only

4.2 CRs resolved with this release

CR

Description

276973

New Feature: New Find and Replace options let you search for and replace strings in specific modules. Find and Replace options are available in the Comm Channel, Mailbox, Trade Partner, Company ID, and Process modules. See the EDI Product 4.2 New Features Guide for additional information.

291351

Problem: GetMessage command seems to permanently remove messages from the queue.

Resolution: When the GetMessage command gets a message from the queue, the message is temporarily removed from the queue. If you want to put the message back onto the queue, use a RestoreMessage command. If you want to permanently remove the message from the queue, use a RemoveMessage command.

When the script exits, any messages temporarily removed by the script will be removed permanently.

318262

New Feature: New wsproces command line arguments support parameter passing. The switches for these parameters are –p1 to –p20.

With these new switches, you can pass parameters from the command line to scripts. This new feature is supported by both wsproces DLL and executable. See the EDI Products 4.2 New Feature Guide for additional information.

330141

New Feature: A new Copy Processes command is available in the Process module that lets you copy a process (or script) from the current DSN (specified by the current system) to another DSN (may be specified by any system).

This lets you run the same process against multiple Trading Partner databases.

331033

Problem: Reports are failing to run when the Trade Partner and Log DSNs are different.

Resolution: This has been fixed for 4.2. There are now two sets of reports, one will be called when the TP and Log are in the same database and one will be called when the TP and Log are in different databases. This will work w/out user intervention in all cases except when the user has two different DSN names pointing to the same database for TP and Log.

340539

Problem: Reports generate an 'error detected by database dll' error when the Trade Partner database is different from the system database.

Resolution: When the Trade Partner and Log DSNs were the same, there was no issue. However, when the Trade Partner and Log DSNs were different, the above error was received. The reports have been modified so they will work in either circumstance.

348251

Problem: If the database supports table ownership but the environmental variable ALL_TB_OWNERS is not set, there is no change in processing.

Resolution: If the database supports table ownership and the environmental variable ALL_TB_OWNERS is set, the code will first attempt to get a match on both table name and owner name as usual.

But if there is a match on table name, but no match on owner name, the code will check further to see if the current user has read and delete privileges on the table. If the current user does have these privileges, then the code returns to ECGATEWAY or ECMAP the return value to indicate that the table exists.

353439

Problem: EC Gateway 2.9.5 process failed running in 4.0.6 if the process contained a String Concatenate command. The process had to be recompiled to run properly.

Resolution: Fixed. These processes would now run without recompilation.

353929

Problem: When EC Gateway 2.9 scripts with a StringFind command were run on EDI 4.0.6 they failed unless they were recompiled.

Resolution: Fixed. They now run without recompilation.

355525

Problem: In EC Gateway, the copy command on UNIX copy did not replicate the permissions of the source file onto the destination file.

Resolution: Fixed. File permissions are now the same on the original and on the copied file.

355953

Problem: wsproces scripts that called pfsasync with a script name were hanging.

Resolution: Problem corrected.

357421

Problem: In the Email command screen, when a Gateway filename is used as the Message To Send, the command failed with the message: Invalid Indicator for Message To Send. This failure occurred in EBF 4.0.6 but not in EBF 4.0.5.

Resolution: Fixed.

358508

Problem: wsproces scripts compiled before EBF 4.0.6, failed to run EFTP, unless recompiled.

Resolution: wsproces and EFTP were modified to allow versions, compiled prior to 4.0.6, to run EFTP without requiring recompilation.

364009

Problem: In EC Gateway 4.0.6 running with MQ Series 5.3 and Win2K SP4 that writes messages to a queue and a Parameter is used for the CommChannel, a Dr. Watson type memory error occurs after writing a few successful messages. There is no problem when a simple CommChannel name is used, instead of a parameter.

Resolution: Fixed.

4.3 Updates and clarifications

4.3.1 Moving messages on and off queue

If your script includes multiple GetMessage statements, you must include explicit commands to move messages on and off the queue.

Each GetMessage statement gets a message from the queue; the message remains on the queue but is marked as having been read. To permanently remove the message from the queue, use a RemoveMessage command. To replace the message on the queue, as though it had not been read, use the RestoreMessage command.

4.3.2 Scheduling tasks at the end of the year

If you want Scheduler to run tasks from the end of one year to a next date in the upcoming year, check the End Date/Time values in Advanced Scheduling. Set the correct field values or disable them completely.

Use these instruction to schedule end of year processing:

  1. Start the Scheduler module.

  2. Click Task, choose Add.

    – Or –

    Right-click a task, choose Edit.

  3. Bring the Scheduler tab into focus. From the Frequency drop down box, choose Monthly.

  4. In the Properties group, choose Run each month(s) using the next scheduled.

  5. Click Months, then choose the months you want to schedule the run.

  6. Click Advance Scheduling. Do one of the following:

    • Make sure the End Date/Time fields values are correct.

      – Or –

    • Uncheck the End Date/Time check box. You must deselect this value for monthly transactions to cross yearly boundaries.

4.3.3 Setting the polling intervals in UNIX

You can now set the scheduling resolution from the command line when you start the UNIX Scheduler daemon with the “-r” switch followed by the number of seconds. Sybase recommends a time greater than 5 seconds and less than 60 seconds. This depends on how many tasks you need to run plus their frequency.

4.3.4 Database size

Although the amount of free space required to upgrade the log table varies, the amount of free space in the database should be greater than the size (including data) of the current log table (TRLOG). If the amount of free space is greater, the upgrade should succeed. If not, the process will fail.

4.3.5 997 Run IDs

New wsproces command line arguments support parameter passing, including run IDs for 997 maps. The switches for these parameters are –p1 to –p20. With these new switches, you can pass parameters from the command line to scripts. This new feature is supported by both the wsproces DLL and executable. See the EDI Products 4.2 New Features Guide for additional information.

4.3.6 Switch options

See the EDI Products 4.2 New Features Guide for a list of new and obsolete features.

4.3.7 Additional table documentation

Some customers requested additional documentation about the ACKTA1, PWD_GEN and SYS_SECU tables.

ACKTA1 Table

Column Name

Data Type

Length

Description

RUN_ID

Integer

9

Normal Run ID

RUN_DATE

Date/Time

8

Normal Run Date

SEND_QUAL

Alphanumeric

4

Sender qualifier from originating Interchange

SEND_CODE

Alphanumeric

35

Sender Code from originating Interchange

RECV_QUAL

Alphanumeric

4

Receiver Qualifier form originating Interchange

RECV_CODE

Alphanumeric

35

Receiver Code from originating Interchange

INTERCHANG

Alphanumeric

35

Interchange Control Number

ORIG_INT_NUM

Alphanumeric

35

Interchange Control Number from originating interchange

ORIG_DATE

Alphanumeric

6

Date of originating interchange

ORIG_TIME

Alphanumeric

4

Time of originating interchange

INT_ACK_CD

Alphanumeric

1

Acknowledgement code for originating interchange (Accepted, Rejected, etc.)

INT_NOTE_CD

Alphanumeric

3

Type of Error (if any) for the originating interchange

SYS_SECU Table

Column Name

Data Type

Length

Description

GW_VERSION

Alphanumeric

50

Gateway version number

ONE_USERID

Alphanumeric

1

Flag for Unique User ID for Communication Channels

ONE_LOGIN

Alphanumeric

1

Flag for Unique Login for Each Communication Channel

ONE_ALPHA

Alphanumeric

1

Flag for At Least One Alphabetic Character in the Password of Communication Channels

ONE_DIGIT

Alphanumeric

1

Flag for At Least One Numeric Character in the Password of Asynchronous Channels

PWD_MINLEN

Integer

10

Minimum Password Length in Communication Channels

BAD_ATTEMP

Integer

10

Lockout after Bad Attempts

PWD_EXPIRE

Integer

10

Password Expires after Days

PWD_GEN

Integer

10

Generations for Password History

PWD_GEN Table

Column Name

Data Type

Length

Description

USER_ID

Alphanumeric

50

User ID for the Gateway Communication Channels

USER_TYPE

Alphanumeric

50

Communication Channel Type

PWD_GEN

Integer

10

Which Generation for the Password History

USER_PWD

Alphanumeric

50

Password for the Gateway Communication Channels

5. ECRTP

ECRTP is a data transformation engine, which analyzes, transforms, and routes messages. ECRTP includes map files, trading partner database, and log files.

5.1 Documentation

This table identifies documentation specific to ECRTP 4.2.

Title

Description

Location

ECRTP Reference Guide

Intended for map developers, this document tells you how to use ECRTP to analyze, transform, and route messages.

ecrtprg.pdf in \doc folder of your install directory.

ECRTP Installation Key

Includes the product key you need to install ECRTP.

Print only

5.2 CRs resolved with this release

CR

Description

308309

Problem: When running ECRTP the error message when missing an ST is confusing.

Resolution: ECRTP has been updated to correctly report an error when the ST is missing.

351165

Problem: The behavior of 4.0.5 ECRTP on AIX was different from 4.0.5 ECRTP on other platforms and 4.0.3 on all platforms. There are two errors related to this problem. Incorrect error messages were generated and invalid null values were output instead of spaces.

Resolution: The problem was caused by a local variable not being initialized correctly. The local variable was identified and is now initialized correctly.

351951

Problem: ECRTP did not correctly check for minimum length errors for decimal data types. The definition of the decimal datatype says, “The length of a decimal type data element does not include the optional leading sign or decimal point”. Thus '.294' will be an invalid value if the minimum length of the element is 4. ECRTP caught this error on all other decimal data types except for Real Number.

Resolution: Fixed. Minimum length requirements for the Real Number data type is now computed correctly.

354659

Problem: When there is mixture of good and bad ST/SE segments in the input EDI file, one extra bad SE segment was generated and written into the good.edi file. This extra bad SE segment belongs to one ST/SE section and should only be written into the bad.edi file.

Resolution: ECRTP's logic was changed to determine whether the current segment will be written into output stream or not.

354659

Problem: When there are mixtures of good and bad ST/SE segments in the input EDI file, one extra bad SE segment was generated and written into the good.edi file. This extra bad SE segment belongs to one ST/SE section and should only be written into the bad.edi file.

Resolution: ECRTP's logic was changed to determine whether the current segment will be written into output stream or not.

355941

Problem: Running supplied inbound map and input file, no CLM1101 data is used, however invalid error: “(1297) ERROR: Value- is not found in Table- Causes.XRF” is reported.

Resolution: ECRTP will process the entire segment looking for data. This includes running cross-reference tables when encountered. In order to avoid the error above, a blank entry should be added to the cross-reference table. Once this is done, the error will no longer be received. It is recommended that a blank entry be added to cross-reference tables in which this error (in this case) is not wanted.

356592

Problem: A change was made that disallowed Trade Agreement routing in EC Gateway.

Resolution: Fixed. Now both Trade Partner and Trade Agreement routing work through EC Gateway.

5.3 Updates and clarifications

5.3.1 Multiple file processing and KeyField/Linkfield match

ECRTP uses KeyFields and LinkFields to process outbound user files. Some customers requested additional information to explain why a record remains in the buffer even if a KeyField/LinkField break was hit when reading it. The record remains in memory by design.

For example, if ECRTP processes a purchase order file and a line item file, RTP reads a purchase order number, and then starts to read line items from the line item file. When RTP reads a line item record that does not share the same link field with the purchase order, the program breaks, but keeps the line item record in memory. Processing of the line item record occurs after RTP reads a new purchase order that matches the line item record's link field.

5.3.2 File size limitation

ECRTP has a limitation of 2GB on the maximum file size it can process.

6. ECRTP/TP

ECRTP/TP provides a processing environment that uses the Run Time Program (RTP) to manage projects, run maps, convert data, perform basic trading partner operations, and test new maps.

6.1 Documentation

This table identifies documentation specific to ECRTP/TP 4.2.

Title

Description

Location

ECRTP/TP Reference Guide

Provides instructions you need to use ECRTP/TP to manage projects, run maps, convert data, and perform basic trading partner operations.

ecrtptp.pdf in \doc folder of your install directory.

ECRTP/TP Installation Key

Includes the product key you need to install ECRTP/TP.

Print only

7. Adapter for EDI

Adapter for EDI supports EDI exchange by translating EDI data formats required by your EAI server.

7.1 Documentation

This table identifies documentation specific to Adapter for EDI 4.2.

Title

Description

Location

Adapter Runtime Environment for EDI User Guide

Tells you how to configure, test, and run the Adapter Runtime Environment.

adaptug.pdf in \doc folder of your install directory.

e-Adapter Development Kit Developer’s Guide

Tells you how to use the tools and libraries that simplify development of adapters that interface with web-based, packaged, and legacy applications.

adaptdg.pdf in \doc folder of your install directory.

8. Technical support

Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you have any questions about this installation or if you need assistance during the installation process, ask the designated person to contact Sybase Technical Support or the Sybase subsidiary in your area.

9. Other sources of information

Use the Sybase Getting Started CD, the SyBooks CD, and the Sybase Product Manuals Web site to learn more about your product:

9.1 Sybase certifications on the Web

Technical documentation at the Sybase Web site is updated frequently.

Finding the latest information on product certifications

  1. Point your Web browser to Technical Documents.

  2. Select Products from the navigation bar on the left.

  3. Select a product name from the product list and click Go.

  4. Select the Certification Report filter, specify a time frame, and click Go.

  5. Click a Certification Report title to display the report.


Creating a personalized view of the Sybase Web site (including support pages)

Set up a MySybase profile. MySybase is a free service that allows you to create a personalized view of Sybase Web pages.

  1. Point your Web browser to Technical Documents.

  2. Click MySybase and create a MySybase profile.


9.2 Sybase EBFs and software maintenance

Finding the latest information on EBFs and software maintenance

  1. Point your Web browser to the Sybase Support Page.

  2. Select EBFs/Maintenance. If prompted, enter your MySybase user name and password.

  3. Select a product.

  4. Specify a time frame and click Go. A list of EBF/Maintenance releases is displayed.

    Padlock icons indicate that you do not have download authorization for certain EBF/Maintenance releases because you are not registered as a Technical Support Contact. If you have not registered, but have valid information provided by your Sybase representative or through your support contract, click Edit Roles to add the “Technical Support Contact” role to your MySybase profile.

  5. Click the Info icon to display the EBF/Maintenance report, or click the product description to download the software.




Back to Top
© Copyright 2010, Sybase Inc.