http://forums.visokio.com/discussions/tagged/Scheduler_Actions/p2/feed.rss Mon, 30 Oct 17 13:49:16 -0400 Tagged with Scheduler_Actions - Visokio Forums en-CA http://forums.visokio.com/discussion/1257/scheduler-data-conversiontransformation-warning-error-in-schedule-job Thu, 26 Jan 2012 09:33:26 -0500 TomRiggs 1257@/discussions
2012.01.26 09:04:25.859 Warning: Action completed successfully but warnings generated:

fixing
Unknown class class [B; defaulting to String
Unknown class class [B; defaulting to String
Unknown class class [B; defaulting to String]]> http://forums.visokio.com/discussion/1099/scheduler-suppressignore-error-messagess Thu, 17 Nov 2011 08:41:15 -0500 edtclarke 1099@/discussions C:\Program Files (x86)\Visokio Omniscope\OmniscopeEnterprise.exe -executeAction "C:\SSIS\Omniscope\0.Input\WWSA_Cat12.xml"

For a folder full of xml source data files. The problem I have is that if one of the xml files causes Omniscope to error the job will not continue until I manually 'Ok' the error message.

Is there a way to suppress or ignore any error messages - I have a validation process checking at the end of the job whether all the files have been built. Thanks -Ed]]> http://forums.visokio.com/discussion/1087/refresh-from-source-task-of-database-blockodbc-fails-to-execute. Tue, 08 Nov 2011 12:24:01 -0500 Aruna 1087@/discussions
When I refresh the Source manually from the Omniscope window, (Tools -> Update Data) the data is refreshed correctly.
When I use the "Refresh" Button on the Omniscope window, it also refreshes correctly. When I use the "Update All" button, Sometimes the data is refreshed, sometimes the Database error occurs. When I save and Reopen the file, then it works.
Qn: Why is the Data Refresh from the same source show such inconsistency?

When the iok file is Scheduled to be refreshed (Refresh from Source), it always fails and throws an ODBC Error.
This is the Error message from the Scheduler
..
CAUSE: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)...

I use 64 bit versions of Oracle Drivers and 64 bit ODBC, Java and Omniscope Applications.

Qn:Why does the Scheduler always fails to execute this Task? How can I overcome this issue?

Thanks.]]> http://forums.visokio.com/discussion/826/scheduler-execute-command-action Thu, 16 Jun 2011 07:42:19 -0400 neilmerchant 826@/discussions
choice /c 1 /d 1 /t 60 >nul

Any other ideas on how to fix this or how I can make it wait for a file to exist?
Regards, Neil]]> http://forums.visokio.com/discussion/919/scheduler-automated-data-refresh-clearing-the-disk-cache Tue, 09 Aug 2011 13:45:00 -0400 Mees 919@/discussions
Sometimes we notice that the final DM block indicates the full DM process is ready (by showing the Load button), while somewhere upstream some blocks are still running. Are you aware of this behaviour? And how can we prevent it?

Now we are using the server edition and we run some DM files in sequence in the scheduler. We have the feeling that some blocks haven't been completed because we miss some data in our final Omniscope files. A reason could be what I have described above: the final block was loaded in Omniscope too early. We can't check this however, as the scheduler runs these files in the background.

Can you please help as this is important for us. We must be able to trust the DM processes completely otherwise we are publishing incomplete information.

Many thanks

]]> http://forums.visokio.com/discussion/903/scheduler-creating-files-with-unique-filenames Tue, 02 Aug 2011 15:43:20 -0400 Mees 903@/discussions As we need a unique filename per file, we use the timestamp to include in the filename.

However, we are facing a problem we didnt expect..... The process runs so fast that some files are created in the same second. This means we loose the functionality of creating unique filenames.

To avoid this situation we need to slow down the scheduler process, of course something we do not want.
As a workaround we inlcude the File action 'Save iok' to win some time before the next file is generated.

We hope there is a better solution.
1 - have a least 1 or 2 seconds between file creation
2 - have another way to create a unique file name; ideal would be to use an ID field in the filename

Thanks
]]> http://forums.visokio.com/discussion/900/scheduler-copy-taskss Mon, 01 Aug 2011 07:25:32 -0400 Mees 900@/discussions http://forums.visokio.com/discussion/448/scheduler-submitting-xml-actions-when-running-scheduler-as-a-services Thu, 14 Oct 2010 15:32:16 -0400 Guy_Cuthbert 448@/discussions