Error during processing - Converting Date/Timehttps://joellipman.com/articles/else/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 interface are very similar when developing reports though. The error I'd get was An error occurred during local report processing. An error has occurred during report processing. Cannot read the next data row for the dataset DataSet1. Conversion failed...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

SSRS Report Builder 2.0 - Error during processinghttps://joellipman.com/component/content/article/ssrs-report-builder-20-error-during-processing.html?catid=75&Itemid=165

06 May 2010 a report and on running it, Report Builder 2.0 returns the following error: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The variable name '@GroupName'...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Parameters not being used in report processinghttps://joellipman.com/component/content/article/parameters-not-being-used-in-report-processing.html?catid=75&Itemid=165

07 January 2011 Once again I've spent a whole morning going in the wrong direction with a convincing SQL script. This article is just a note on when using Business Intelligence Development Studio (BIDS) or Report Builder 2.0 and when previewing the report, the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

28 June 2011 however and whenever YOU want. Unlimited: You are only limited by the resources of your environment setup, in terms of processing and disk space. The program doesn't care what sites you've done or how many times you used it (no audit trail)....

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 So Shopify want your webhooks to respond within 1 second. This is about enough time to store the record but that's it. Processing the record must be done at a later time or in a different process but sometimes it simply will not process it all and...

• Type: Article
• Author: Joel Lipman
• Category: Shopify
• Language: *

ZohoCRM: Process all records of a modulehttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-process-all-records-of-a-module.html

24 August 2021 A quick article to document a method of looping through all the records of a module and processing these with the ability auto-resume without processing the same record twice. Why? Whether you have a few hundred records, or a few hundred thousand...

• Type: Article
• Author: Joel Lipman
• Category: Zoho CRM
• Language: *

SSIS Convert a string into a datehttps://joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

14 March 2013 The ProcessInput method on component "Convert Date" (4228) failed with error code 0xC0209029 while processing input "Derived Column Input" (4229). The identified component returned an error from the ProcessInput method. The error is specific to the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Returned a data type that is not validhttps://joellipman.com/articles/else/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report processing. The Group expression used in grouping 'table1_month' returned a data...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Using a HTML form and PHP to upload a filehttps://joellipman.com/articles/cms/website-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 form above will post to itself but more importantly is the enctype="multipart/form-data" without which your file upload processing won't work. The name of the file is important but you can call it what you want, in my case I've called it...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://joellipman.com/articles/cms/website-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 error : Input is not proper UTF-8, indicate encoding ! Bytes: 0xA0 0x3C 0x2F 0x73 in /home/public_html/my_folder/my_xml_processing_script.php on line 160 Why? I'm downloading an XML feed to our servers, and then loading the downloaded file into memory...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Autohotkey Count Number of Files/Folders in a Directoryhttps://joellipman.com/component/content/article/autohotkey-count-number-of-files-folders-in-a-directory.html?catid=48&Itemid=165

04 June 2013 on a local drive. Try using this over a networked drive and more time will be spent counting the files then the actual processing (or whatever your script is trying to do). Method #2: FileSystemObject ComObjCreate UserFolder:="C:" -- to return file...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

23 February 2014 :: take parameters from the named JOB file. /SAVE:jobname :: SAVE parameters to the named job file /QUIT :: QUIT after processing command line (to view parameters). /NOSD :: NO Source Directory is specified. /NODD :: NO Destination Directory is...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: en-GB

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 m_RelatedList.put("data",l_DataRows); return m_RelatedList; Error(s) Encountered Sorry, there was a problem processing your request.: Your returned XML is invalid Sorry, there is a tag discrepancy in the function. The related list cannot be displayed.:...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Books
• Language: *

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 the file, this error no longer appears. This error seems to be at the end of a function which has already done a lot of processing. Here's a quick test snippet of code: void fn_UploadTest() { // // selecting a record which has a file upload field that...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Creator
• Language: *

PHP Script: Make your own Thumbnail Generator via APIhttps://joellipman.com/articles/cms/website-development/php/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 } Permissions & Logging • Ensure PHP can write to _origs and _thmbs. • Optionally monitor or rotate logs for download and processing errors.

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

SSRS Redirect after a report is runhttps://joellipman.com/component/content/article/ssrs-redirect-after-a-report-is-run.html?catid=75&Itemid=165

12 August 2011 nowhere: ssrs process parameter after report execution auto-redirect after are a report is run ssrs vbscript post report processing ssrs auto redirect based on a dataset value

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Performance Report - Background colors based on dataset valueshttps://joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

02 December 2011 one. The breakdown or what I was able to measure with the default installation are the times taken for "data retrieval", "processing", "rendering", and then the totals of these. I haven't Googled this at the time of print so there may be a million...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

07 March 2014 extra 9 minutes come from? Not the SQL as this runs in 00:00 seconds in SQL Server Management Studio. Not the internal processing and rendering as the report server says it did this in 0.4 seconds. So where's the problem? How? Left to its own devices, a...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

The ReportServer Databasehttps://joellipman.com/articles/else/database/the-reportserver-database.html

08 August 2011 finished running? Need to check what finished? TimeDataRetrieval int NOT NULL Milliseconds spent retrieving the data. TimeProcessing int NOT NULL Milliseconds spent processing the report. TimeRendering int NOT NULL Milliseconds spent rendering the...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/else/database/oracle-pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 when no rows are returned. This does not affect the above problem as the stored procedure simply fails and discontinues processing the overall report. How? Browsing the web for a solution, most suggest using NVL() but this only replaces a NULL value...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB