I am brand new to data remediation and am still busy with the design for our data remediation processes. I am currently configuring the landscape by creating the applications, subject areas and issue types. I want to create an issue type for each field in our data - which is a lot so I don't want to do it manually as I would want to replicate it in our DEV, TEST and PROD environments and I would also like to be able to dynamically add an issue type if a new field is added. Is there a way to programmatically add issue types from SQL tables? I have googled but haven't been able to find anything yet, so any help will be greatly appreciated. ... View more

Hi All I have a VERY basic question to ask, I am sure I am missing something completely but for the life of me I can't see what. I need to create a macro variable with the current datetime in a specific format. I am using an expression node, but when I preview the expression node, there is no value in the field.   Here is my code (I added some test variables, and all of these are empty when I preview the node):   Pre-processing: string CurrDateTime date test1 string test2   Expression: CurrDateTime=formatdate(today(),"YYYYMMDD_hhmmss") test1 = today() test2="This is a test string" varset ("Inp_CurrDateTime", CurrDateTime)     If anyone can tell me what obvious step I am missing, I would be very grateful. Thanks! ... View more

Hi All I am ding a load of 183m rows from Dataflux into a SQL Server table. The current job is just a normal insert, but I am playing around with the bulk row count option to see if I can't speed it up (it ran for 42 hours). However, I am getting an error with a datetimeoffset field. The field seems to be a character value in Dataflux, so I would have thought it would be coerced into a datetime value, but I get this error:  [4:DEST_ODBC:Consolidated Customer Matchcode] Data Access Plugin - Max. ODBC error count (49999) exceeded. Last error: [22018] [DataFlux][ODBC SQL Server Wire Protocol driver]Invalid character value. Error in parameter 11. (0);[HY008] [DataFlux][ODBC SQL Server Wire Protocol driver]Operation cancelled. Error in parameter 116. (0).   I then created a new date variable and converted the character value to a date field (date DOB DOB=todate(left(DateOfBirth,10)), and mapped that to the datetimeoffset field, but I am still getting the same error. Has anyone had any experience with this, and can offer some suggestions, please?   To complicate matters further, it runs fine locally but gives that error when running on the server, so I assume it is using different ODBC drivers. ... View more

Hi! Has anyone ever encountered this problem: it has happened twice to me where some of my business rules became blank. I.e. the business rules just suddenly had no expressions linked to them, even though they were 100% previously. It seems to happen when I go from one environment to another (e.g. from development to test environment). The business rules then become blank in both environments. Anyone had this happen to them? ... View more

I am new to using work tables and am working on a job developed by someone else. I added a field to a work table, and I now want to add it as output in the work table reader node, but there is no option to add an output. Any advice would be appreciated please! ... View more

I am using the File Reader transformation in DI Studio to import a pipe delimited text file. Some of the fields contain quotes, and I ant to remove the dsd option from the generated code so that the quotes are not seen as delimiters. The problem is I can't find the option in the transformation to do this! Any suggestions? ... View more

Hi All I recently migrated our data quality assessment to our production environment, and when I ran it for the first time OF COURSE it failed. I am trying to find out why it failed, but when I try to open the first rule that failed, I get this error message:   Error occurred while retrieving rule list: Expression plugin in - Repository 'Server Repository' not found.    I tried googling the error message, but couldn't find anything relevant. Has anyone else encountered this error message before? ... View more

Good day I am trying to import business rules into my UAT repository and am getting the errors as depicted in the attachment. I have asked our SQL DBAs to ensure I have read and write access on the database, and I also have full access to the file storage system. Has anyone ever encountered errors like these and do you perhaps have advice on how to resolve it, please? Thanks! ... View more