Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Variable Seems to Be Incrementing

Variable Seems to Be Incrementing 1 month 2 days ago #19436

I have a database Lookup for a variable using a Set Variable

VarName VarValue
<FileSourceName> MP_20190920_067_2_0001
<FileOutputName> RFMK1909230067

When i use the <FileOutputName> its wrong , it increments the string

Information 9/20/2019 5:49:15 PM Executing File Operation: File Operation TIF 2
Information 9/20/2019 5:49:15 PM Path: \\tapfs01\Combined\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201651110067\
Information 9/20/2019 5:49:15 PM Mask: MP_20190920_067_2_0001.tif
Information 9/20/2019 5:49:15 PM Path Is Valid: True
Information 9/20/2019 5:49:15 PM Include Directory: False
Information 9/20/2019 5:49:15 PM In Sub Folders: False
Information 9/20/2019 5:49:15 PM Attributes: ReadOnly
Information 9/20/2019 5:49:15 PM Attribute: Hidden
Information 9/20/2019 5:49:15 PM Attribute: SysFile
Information 9/20/2019 5:49:15 PM Attribute: aArchive
Information 9/20/2019 5:49:15 PM File Age: 30
Information 9/20/2019 5:49:15 PM Which File: 0
Information 9/20/2019 5:49:15 PM Found: 1 File(s)
Information 9/20/2019 5:49:15 PM File renamed: \\tapfs01\Combined\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201651110067\MP_20190920_067_2_0001.tif
Information 9/20/2019 5:49:15 PM To: \\tapfs01\Combined\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201651110067\RFMK1909240067[/b].tif
Attachments:

Please Log in or Create an account to join the conversation.

Variable Seems to Be Incrementing 1 month 2 days ago #19437

v6.3.5.4 32bit

this is happening and is a problem variables are incrementing for no reason

IMGBATXMKMPCKG201909201707330080 suddenly becomes
IMGBATXMKMPCKG201909201707340080

see a .log entry of the issue

Information 9/20/2019 8:16:20 PM Success
Information 9/20/2019 8:16:20 PM Executing File Operation: Archive Dir
Information 9/20/2019 8:16:20 PM Directory created: \\serverx\clientx\PROD_S78\MPLHWORK\ARCHIVE\IMGBATXMKMPCKG201909201707330080
Information 9/20/2019 8:16:20 PM Executing File Operation: Archive A
Information 9/20/2019 8:16:20 PM Path: \\serverx\clientx\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201707330080\
Information 9/20/2019 8:16:20 PM Mask: *.*
Information 9/20/2019 8:16:20 PM Path Is Valid: True
Information 9/20/2019 8:16:20 PM Include Directory: False
Information 9/20/2019 8:16:20 PM In Sub Folders: False
Information 9/20/2019 8:16:20 PM Attributes: ReadOnly
Information 9/20/2019 8:16:20 PM Attribute: Hidden
Information 9/20/2019 8:16:20 PM Attribute: SysFile
Information 9/20/2019 8:16:20 PM Attribute: aArchive
Information 9/20/2019 8:16:20 PM File Age: 30
Information 9/20/2019 8:16:20 PM Which File: 0
Information 9/20/2019 8:16:20 PM Found: 4 File(s)
Information 9/20/2019 8:16:20 PM Copied file \\serverx\clientx\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201707330080\PAMK1909230080.tif into \\serverx\clientx\PROD_S78\MPLHWORK\ARCHIVE\IMGBATXMKMPCKG201909201707330080\PAMK1909230080.tif
Information 9/20/2019 8:16:20 PM Copied file \\serverx\clientx\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201707330080\PAMK1909230080.xml into \\serverx\clientx\PROD_S78\MPLHWORK\ARCHIVE\IMGBATXMKMPCKG201909201707330080\PAMK1909230080.xml
Information 9/20/2019 8:16:20 PM Copied file \\serverx\clientx\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201707330080\RNMK1909230080.tif into \\serverx\clientx\PROD_S78\MPLHWORK\ARCHIVE\IMGBATXMKMPCKG201909201707330080\RNMK1909230080.tif
Information 9/20/2019 8:16:20 PM Copied file \\serverx\clientx\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201707330080\RNMK1909230080.xml into \\serverx\clientx\PROD_S78\MPLHWORK\ARCHIVE\IMGBATXMKMPCKG201909201707330080\RNMK1909230080.xml
Information 9/20/2019 8:16:20 PM Executing Zip: ZIP Operation
Information 9/20/2019 8:16:20 PM Zip File : \\serverx\clientx\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201707330080.zip
Information 9/20/2019 8:16:20 PM Path: \\serverx\clientx\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201707330080\
Information 9/20/2019 8:16:20 PM Mask: *.*
Information 9/20/2019 8:16:20 PM Path Is Valid: True
Information 9/20/2019 8:16:20 PM Include Directory: False
Information 9/20/2019 8:16:20 PM In Sub Folders: False
Information 9/20/2019 8:16:20 PM Attributes: ReadOnly
Information 9/20/2019 8:16:20 PM Attribute: Hidden
Information 9/20/2019 8:16:20 PM Attribute: SysFile
Information 9/20/2019 8:16:20 PM Attribute: aArchive
Information 9/20/2019 8:16:20 PM File Age: 0
Information 9/20/2019 8:16:20 PM Which File: 0
Information 9/20/2019 8:16:20 PM Found: 4 File(s)
Information 9/20/2019 8:16:20 PM Source File : \\serverx\clientx\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201707330080\PAMK1909230080.tif
Information 9/20/2019 8:16:20 PM Source File : \\serverx\clientx\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201707330080\PAMK1909230080.xml
Information 9/20/2019 8:16:20 PM Source File : \\serverx\clientx\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201707330080\RNMK1909230080.tif
Information 9/20/2019 8:16:20 PM Source File : \\serverx\clientx\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201707330080\RNMK1909230080.xml
Information 9/20/2019 8:16:20 PM Finished Executing Zip: ZIP Operation
Information 9/20/2019 8:16:20 PM Executing Gpg4Win : Gpg4win

... ...

Information 9/20/2019 8:16:22 PM Executing File Operation: Archive
Information 9/20/2019 8:16:22 PM Path: \\serverx\clientx\PROD_S78\MPLHWORK\MP_ZIPBUFFER\
Information 9/20/2019 8:16:22 PM Mask: IMGBATXMKMPCKG201909201707340080.*
Information 9/20/2019 8:16:22 PM Path Is Valid: True
Information 9/20/2019 8:16:22 PM Include Directory: False
Information 9/20/2019 8:16:22 PM In Sub Folders: False
Information 9/20/2019 8:16:22 PM Attributes: ReadOnly
Information 9/20/2019 8:16:22 PM Attribute: Hidden
Information 9/20/2019 8:16:22 PM Attribute: SysFile
Information 9/20/2019 8:16:22 PM Attribute: aArchive
Information 9/20/2019 8:16:22 PM File Age: 30
Information 9/20/2019 8:16:22 PM Which File: 0
Error 9/20/2019 8:16:22 PM Could not find any files
Information 9/20/2019 8:16:22 PM Executing File Operation: Clear Folder - Working Files
Information 9/20/2019 8:16:22 PM Path: \\serverx\clientx\PROD_S78\MPLHWORK\MP_ZIPBUFFER\IMGBATXMKMPCKG201909201707340080\
Information 9/20/2019 8:16:22 PM Mask: *.*
Information 9/20/2019 8:16:22 PM Path Is Valid: False
Information 9/20/2019 8:16:22 PM Include Directory: False
Information 9/20/2019 8:16:22 PM In Sub Folders: False
Information 9/20/2019 8:16:22 PM Attributes: ReadOnly
Information 9/20/2019 8:16:22 PM Attribute: Hidden
Information 9/20/2019 8:16:22 PM Attribute: SysFile
Information 9/20/2019 8:16:22 PM Attribute: aArchive
Information 9/20/2019 8:16:22 PM File Age: 30
Information 9/20/2019 8:16:22 PM Which File: 0
Error 9/20/2019 8:16:22 PM Could not find any files

Please Log in or Create an account to join the conversation.

Variable Seems to Be Incrementing 4 weeks 1 day ago #19438

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7646
  • Karma: 33
  • Thank you received: 427
Hello

We are unable to reproduce the problem.
Perhaps you can create a very simple package demonstrating it?
Mike

Please Log in or Create an account to join the conversation.

Variable Seems to Be Incrementing 3 weeks 3 days ago #19441

i took my PROD REPO and DB and brought it to my laptop and reconfigured the paths etc and was able to REPRODUCE the error WHEN i used the SAID ETL package.
I then created a brand new package and manually/tediously redid the entire flow same as before, same parameters same settings and the new PACKAGE works flawlessly. So i can only conclude the original package is damaged or something.

I will take the copy of the working DEV package and import it to PROD and test it out of hours.

Please Log in or Create an account to join the conversation.

Variable Seems to Be Incrementing 3 weeks 3 days ago #19442

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7646
  • Karma: 33
  • Thank you received: 427
This can be something else like database issues.

For example if you use float datatype to store variable value.
You insert one value but when you do select you get another value.
Mike

Please Log in or Create an account to join the conversation.

Variable Seems to Be Incrementing 3 weeks 10 hours ago #19456

Thanks, the string in the database is a varchar and the string starts with a TEXT IMGBAT...

i think its the package some how got corrupted, the recreated package works great even in PROD.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 155 guests and no members online