DataStage Error writing record \\\ to file DS_STAGETYPES - error number is 40019

-
Problem(Abstract)

Record OracleConnector on file DS_STAGETYPES cannot be written
Error writing record \\\ to file DS_STAGETYPES - error number is 40019
when the DataStage developer, who only has read access to the project , opens the Oracle Connector stage for the first time.

Symptom

When you open the Oracle Connector stage for the first time you will see the error:

Record OracleConnector on file DS_STAGETYPES cannot be written
Error writing record \\\ to file DS_STAGETYPES - error number is 40019


Cause

When Information Server is installed there are a number of built-in stages which are already 'provisioned' to the template project which include records in the DS_STAGETYPES file.

These built-in stages are in the template project so the built-in stages are automatically included in any projects that are created.

There are a number of stagetypes which are installed in a way that initially only stores them in the repository. The first time the stagetype is referenced in a project the stagetype is provisioned from the repository to the DS_STAGETYPES file in the project directory.


Resolving the problem

IBM provides a client-side tool DSStageTypeUpdater.exe which will provision all available stagetypes to a specified project and to the template project so that any subsequently created projects will include all available stagetypes.


Please run the C:\IBM\InformationServer\Clients\Classic\DSStageTypeUpdater.exe tool as a DataStage Administrator and connect to each existing project. This only needs to be done once.

You can reference C:\IBM\InformationServer\Clients\Classic\DSStageTypeUpdater_readme.txt for instructions on how to use the tool to update all projects.


Source: http://www-01.ibm.com/support/docview.wss?uid=swg21669644







Popular posts from this blog

Shrink you container size up to 95%.

-
BLAFS is a bloat-aware filesystem for container debloating. The design principles of BLAFS are effective, efficient, and easy to use. It detects the files used by the container, and then debloats the container by removing the unused files. The debloated containers are still functional and can run the same workload as the original containers, but with a much smaller size and faster deployment. https://github.com/negativa-ai/BLAFS?tab=readme-ov-file
Read more

alma linux: dnf Module yaml error: Unexpected key in data

-
While applying recent updates to a server running Rocky Linux 8, an error presented itself. Module yaml error: Unexpected key in data: static_context [line 9 col 3] Module yaml error: Unexpected key in data: static_context [line 9 col 3] The solution turned out to be a simple one. Update the libmodulemd first to correct the problem then perform the dnf updates as usual. dnf update libmodulemd For a detailed explanation as to the cause of this problem.
Read more