Activity overview
Latest activity by Avella
mamiller said:
I am writing an IronPython script which reads data from other tables in the server using a SQL connection and query. I am using the library found here to accomplish this: http://www.ironpython.info/index.php?title=Accessing_SQL_Server It has worked for the most part up until recently, with no issues other than timing out if the connection was slow. However, now it seems that something is going wrong when the SQL data is handled in Red Gate. Data that I read into IronPython using that SQL connection can be displayed properly in the preview data generation, but when I actually try to generate the data it fails with a "Can't insert empty sequence" error. The exact same code works perfectly in both PyCharm and Visual Studio; it only fails when the read-in SQL data is handled in a Red Gate IronPython generator for output to the server. Has anyone else had this issue? Any advice is highly appreciated.
I have the same issue. My scenario is just doing a simple query against the other table with a join on the value for the current table, and for the most part works, but will error out with the same message about 50% way through the generation run every time. I suspect there is some issue with connection management. I've wrapped it in a try/except block with a default value, but no luck there. The column is also nullable.
Has anyone identified a means to do logging and debug output during a run for better insights as to where the error lies?
/ comments
mamiller said:
I am writing an IronPython script which reads data from other tables in the server using a SQL connection and query.I am using the library found here to accomplish this:http://...
For further context, I have a python script that generates an email based on a regex. It is wrapped in a try/exception block and returns a default value upon error. The column it populates is nullable. When I run the generator, it will fail anywhere from 100k-500k rows generated with the generic "the value '' cannot be inserted". The log files from the tool are always empty with 0kb. Script: import re import sre_parse re.sre_parse = sre_parse import exrex def main(config): retValue="abc@def.com" try: retValue = exrex.getone('[a-z]{4,8}([0-9]{0,3}|\.[a-z]{4,10})@([a-z]{4,9}\.)?([a-z]{6})\.(org|com|net)') return retValue except: return retValue
/ comments
For further context, I have a python script that generates an email based on a regex. It is wrapped in a try/exception block and returns a default value upon error. The column it populates is nul...
I'm troubled seeing this issue from 4 years ago unanswered. I experience random Python failures with no details other than what the original posted stated. I'm hoping Redgate pays attention to this. / comments
I'm troubled seeing this issue from 4 years ago unanswered. I experience random Python failures with no details other than what the original posted stated. I'm hoping Redgate pays attention to this.
Thats really unfortunate. Given the cost and age of this software, having poor coding practices such as hard coded pathing seems indicative of future support. / comments
Thats really unfortunate. Given the cost and age of this software, having poor coding practices such as hard coded pathing seems indicative of future support.
CSV datasoure from relative path
I have a number of tables that have their data imported from CSV files. It appears the absolute path to these files are saved in the project which it makes it difficult for others to use, or for a...