NextSurrogateKey()
Moderators: chulett, rschirm, roy
NextSurrogateKey()
Hi All,
I am trying to use NextSurrogateKey() in Paralell Transform stage.
I tried to find NextSurrogateKey() usage in all doc's, couldn't find.
Any one idea about NextSurrogateKey() usage.
Thanks
srimitta
I am trying to use NextSurrogateKey() in Paralell Transform stage.
I tried to find NextSurrogateKey() usage in all doc's, couldn't find.
Any one idea about NextSurrogateKey() usage.
Thanks
srimitta
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Ray
I also tried to use Stage but job Aborted with below warning:
Surrogate_Key_Generator_48,0: Internal Error: (start <= end): surrkey/keystate.C: 73
Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH
When checked from command line 'gdb' and 'sed' are working fine.
our OS is Suse-Linux.
Any thought
Thanks
srimitta
I also tried to use Stage but job Aborted with below warning:
Surrogate_Key_Generator_48,0: Internal Error: (start <= end): surrkey/keystate.C: 73
Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH
When checked from command line 'gdb' and 'sed' are working fine.
our OS is Suse-Linux.
Any thought
Thanks
srimitta
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
Hi Ray
I also tried to use Stage but job Aborted with below warning:
Surrogate_Key_Generator_48,0: Internal Error: (start <= end): surrkey/keystate.C: 73
Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH
When checked from command line 'gdb' and 'sed' are working fine.
our OS is Suse-Linux.
Any thought
Thanks
srimitta
I also tried to use Stage but job Aborted with below warning:
Surrogate_Key_Generator_48,0: Internal Error: (start <= end): surrkey/keystate.C: 73
Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH
When checked from command line 'gdb' and 'sed' are working fine.
our OS is Suse-Linux.
Any thought
Thanks
srimitta
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
I could find your posting.
I am running one single simple DS job with Surrogate key generator stage to read value from a flat file.
I am running one single simple DS job with Surrogate key generator stage to read value from a flat file.
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
I could find your posting thanks.
I am running one single simple DS job with Surrogate key generator stage to read value from a flat file.
I am running one single simple DS job with Surrogate key generator stage to read value from a flat file.
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
In version 8.x there is a new tab of the parallel transformer properties called Surrogate Key. Within this tab you define how you want to manage the surrogate key - either flat file or DB Sequence and then in the transformer derivation of the output column you simply invoke NextSurrogateKey().
If you are using a flat file then the value is persisted and if you process 100 rows during a run it will start with something greater than 100 on the next run.
It also appears that the Surrogate Key stage has been extended to include this same functionality.
I have used this and it works well.
If you are using a flat file then the value is persisted and if you process 100 rows during a run it will start with something greater than 100 on the next run.
It also appears that the Surrogate Key stage has been extended to include this same functionality.
I have used this and it works well.
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
I have tried using your method, GREAT, but still I have same error
APT_CombinedOperatorController,1: Internal Error: (start <= end): surrkey/keystate.C: 73
Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH
what does check that 'gdb' and 'sed' are installed and on your PATH
APT_CombinedOperatorController,1: Internal Error: (start <= end): surrkey/keystate.C: 73
Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH
what does check that 'gdb' and 'sed' are installed and on your PATH
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
For future reference, the following message -
can be further broken down by including the APT_DISABLE_COMBINATION. This will allow the error messages to be more specific. Many of the stages are actually combined operators and this makes diagnosis a bit easier.APT_CombinedOperatorController
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
Hey Craig, I found your posting.
This is what with you are trying to help in resloving 'gdb' and 'sed'
can you help me in understand what does check that 'gdb' and 'sed' are installed and on your PATH means
I know how to design DS job as per Ray's advise but client is insisting not to use any Server jobs.
Thanks
This is what with you are trying to help in resloving 'gdb' and 'sed'
- If you run them separately, do they run without this error?
Edit - nm, I see you already said they did. To me, that would imply you could have overloaded your database. There is typically a parameter that controls the number of maximum concurrent connections, perhaps you've blown that limit? A DBA should be able to help...
can you help me in understand what does check that 'gdb' and 'sed' are installed and on your PATH means
I know how to design DS job as per Ray's advise but client is insisting not to use any Server jobs.
Thanks
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
Hi Mhester,
I don't see APT_DISABLE_COMBINATION in job log.
Ok..let me see if I can give you more info, here is the log.
I don't see APT_DISABLE_COMBINATION in job log.
Ok..let me see if I can give you more info, here is the log.
- When APT_DISABLE_COMBINATION is set to False
-Transformer_45,1: Failure during execution of operator logic.
-APT_CombinedOperatorController,0: Internal Error: (start <= end): surrkey/keystate.C: 73
Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH
-node_node2: Player 2 terminated unexpectedly.
-main_program: APT_PMsectionLeader(2, node2), player 2 - Unexpected exit status 1.
- When APT_DISABLE_COMBINATION is set to True
-Transformer_45,0: Failure during execution of operator logic.
-Transformer_45,0: Internal Error: (start <= end): surrkey/keystate.C: 73
Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH
-Transformer_45,1: Failure during execution of operator logic.
-node_node1: Player 5 terminated unexpectedly.
-main_program: APT_PMsectionLeader(1, node1), player 5 - Unexpected exit status 1.
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster