segmentation errors

[Former Member]

Post Author: aschreiber

CA Forum: Data Integration

We are running ETLs that are getting segmentation errors. The Job Server is on an HP-UX Itanium server (HP-UX bizdev1 B.11.23 U ia64 ) and the Designer is on Windows XP. We are on version 11.5.3 of Data Integrator. Has anyone encountered this error and if so how was it resolved.

24611 1 SYS-170101 9/10/07 2:36:23 PM System Exception <Segmentation Violation> occurred in the context <|Dataflow HNS_DF_LOAD_SERVICE_ORDER|Transform24611 1 SYS-170101 9/10/07 2:36:23 PM QRY_ToJoinTwoSources_factServiceOrder>

[Former Member]

Post Author: wdaehn

CA Forum: Data Integration

Can you watch the al_engine process memory via the "top" command of HP-UX? It might be that you run out of memory (2GB is the limit). Especially given the name of you query, you should consider checking the join rank of your two source tables inside the DF, maybe DI caches the wrong one. In other words, is one source small, the other big? The give the big one a join rank of 100, the other a join rank of 1 (everything > 1 is fine, 0 means "automatic").