Data Migration

Does anyone know if there is a limitation on number of rows when migrating using Excel Add-In?I have done a few tests and it seems to be limited to 5000 rows??  

hi All,I can insert or update the schedule in Employee schedule from IFS client , but I can only insert a record in WORK_SCHED_ASSIGN using DMM and update will give an error at the deployment container.My requirement is to use DMM tool to update the schedule from C to B in below IFS window. the CSV file is attached and it looks like : at the deployment container I get below error and the record did not get updated.Method NEW failed : ORA-20110: WorkSchedAssign.INSOVERLAP: Overlapping date intervals.

Hi Experts, at the moment we are trying to configure DMM too to do the migration for a new implementation. The customer hosting the 23R1 version on premise and we are having some hard time to get the DB links works for  non production environment. We have setup the Template project in PROD and then created a project based on the template projects. However, not clear about how we can create DB links to add non production environments as connected environments.  can someone help me to find out the proper way of doing it  like what user we need to use here and stuff like that. Kind Regards!Niyomal.

Morning everyone. I’m working with 11.3.9 and we are going to archive events out of an existing database to standup a new initiative. I want to reset the starting reference numbers for all event types. I know that the event reference numbers for Problems is determined based on the problem_hk table and that the change_hk table determines the event reference numbers for service requests and changes. The incident_hk is used to determine the incident_id (not the incident rerfernce). I also know that Incident, Task and Decisions are sequential and I would assume use the same table to determine the next reference number.My question is this, what table is used to determine the event reference number of Incident/Task/Decision events.

Does anyone know of a way to make this column non mandatory in data migration manager?  Not sure why it would be created this way.  I imported the IFS template.  Version is 23R1 

HiI’m trying to migrate some European addresses which include accents, cedillas and other special characters, for example Île-de-France,  Lérida and straße.I’m using a standalone migration job reading a CSV file (not the Excel add-in).  The characters are displayed correctly in the cs file when viewed in Excel.I’ve tried using the WE8ISO8859P1 character set which I’ve previously used successfully for the degree symbol for temperatures, but the addresses don’t display correctly - Ãle-de-France.Is there a character set which will handle all the main European special characters?Many thanks,Marion

Hey everybody, I am trying to set up an Excel Migration Job for with custom fields. Unfortunately it doesn´t work. Without the CFs I am able to upload data in the master. With the CFs it seems to work (validation and execution works without errors), but the record set doesn´t update. I am curious if someone of you faced the same issue. Name and Cepi have been updated. Validation looks good.After execution it looks also good.

Hi,when sending a HTTP Post request to IFS REST API I get an 400 error as respone.On the IFS Server I see this log message:2023/10/06 06:31:12 [warn] 96#96: *149147568 [lua] cookie.lua:146: bake(): SameSite value must be 'Strict', 'Lax' or 'None' while connecting to upstream, client: x.x.x.x, server: IFS, request: "POST /main/ifsapplications/projection/v1/LocationHandling.svc/LocationSet HTTP/1.1", host: "IFS"The Post request is initiated by our Lobster middleware, using postman everything is working fine. When doing a HTTP Get to request data it is working as epected.Is there some config missing in IFS regarding SameSite cookies or do we have to configure something ob Lobster-side?Thanks,best regards,Nico

Hi,We are deploying customer via DMM onto a connected environment. But we are getting below error. Any idea what permission is missing here. Please note with the same user I am able to create customer manually in the same connected environment Method NEW failed : ORA-20110: CustomerInfo.NOACCESSTOCREATECUSTOMER: You have no permission to create customers of category CustomerORA-06512: at "IFSAPP.ERROR_SYS", line 140ORA-06512: at "IFSAPP.ERROR_SYS", line 354ORA-06512: at "IFSAPP.CUSTOMER_INFO_API", line 2442ORA-06512: at "IFSAPP.CUSTOMER_INFO_API", line 2459ORA-06512: at "IFSAPP.CUSTOMER_INFO_API", line 677 Thanks,Nishith 

I have a lobby that is working in IEE and returning data. But when migrating from IEE to Aurena. I get an invalid data source definition error. The client type is set to Aurena. IN AURENA IN IEE data source:   Also the elements that are returning data are returning null values. Any ideas why this is?

Hi Community. I am having a first look at the Dat Synchronization functionality on IFS Cloud.Documentation is not bad as overview of different aspects, but as a start point, a bit difficult to follow up.Is anyone out there with experience on setting it up, that would be willing to share that knowledge?Thanks for your time!  

Hi,I am trying to complete the task to Define Installed Environment after completing the Basic Project Data for a Data migration job. I am however getting the below error; How can I change the Thousand Separator Format value? 

Hello,In order to load data from INVENTORY_TRANSACTION_HIST2 to DW, it took a lot of time, actually using OBJVERSION to load a latest one but still taking 2 hours only for this table. Is is possible to add a timestamp field directly to a view INVENTORY_TRANSACTION_HIST2, and if any information change in a row the timestamp will be updated ? 

Hi,When importing the template project file for 23R1 I get below error message.  From Background job error textunable to extend index IFSAPP.DAT_TEMPLATE_LOAD_PK by 128 in tablespace IFSAPP_INDEX     ORA-20110: DatFileOperationUtil.ORA-01654Has anyone encounter the same error or can help to resolve this error please?I was using IFS demo environment https://ifs23r1costestlkp.rnd.ifsdevworld.com/  with Alain credentials to import the template project. Thanks!

Just starting out with DMM in IFS Cloud 22R2. I need to pull data from two tables into one target table. The documentation indicates how legacy tables are joined is important but gives no information on how to do this.Somehow this worked when there were two legacy tables with the same key simply by identifying the keys on the Legacy Table definitions.In this new situation, there are three tables involved and I need data from tables T1 & T3. T1 and T2 have the same key. I labeled them Key 1 & 2.T2 and T3 are linked by a different field. I tried labeling these as Key 3, but that did not work.Is this possible to do and if so how?  

I’m executing a loader job via OnServer route and once I select the file from the SFTP Server, getting an error “Invalid value for property “IntfaceFile””. Any suggestion on the reason of this error and how to fix it.Thanks

I am trying to import supplier records into my IFS8 system using xml files generated by an external system. The xml files are supposed to be using utf-8 encoding. However, because some of the records are generated from Korean and Ukrainian sources, not all the characters are utf-8 despite the xml referencing <?xml version="1.0" encoding="UTF-8"?>. As a result, when the connector reader gets the xml file, it reports:com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence.And the file is not processed any further.Sometimes the control characters will clobber the xml tags, which nullifies the entire file structure.Aside from forcing the sender to reformat the data, is there anything I can do in IFS to compensate for the bad characters when the connector reader tries to pick it up?Here is an example of one of the bad xml files opened in notepad++. 

Hi expertsWhen i try to login into the Migration excel add inI always get into this login mask    can i somehow access the system with the migration tool as an admin with the following loginscreen? I allready tried to enter the Admin URL but i always get an error message​​​​

Hello,I am using an external Excel/CSV file as a source, imported by the user into a specific IFS repository. After importing and retrieving the data, I need to store it in multiple IFS tables.Could you please provide guidance on how to achieve this?

Any one know how to download docker container and heml chart for AirGap installation for IFSCloud 23R1?Where should i find the “download.sh” file?  ./download.sh -u your_username -p your_password -j jfrog_artifactory_url -r x.y.z --ifs-helm 

Hello want to build migration job wich based on the service resource assistant creation. The reousrce will be based on existing person and resource group. Is it something we can do by using the API method ? and if yes where i can find list of method of this API or have acces to the view.New service resource creation 

I am looking for a way to run a replication job for Inventory Parts from Contract A to Contract B. However, I want to change the value of a few fields when it goes to Contract B. Overall, we are changing to streamline our part creation process and one of the challenges we have faced was trying to replicate 80% of the inventory part into a new contract, but there are few value changes. Example would be Inventory Part Planner 17 for Contract A = Inventory Part Planner 20 for Contract B. Is it possible to change values of certain fields through the replication job? 

Hello IFS Community, I hope you're all doing well. I'm currently in the process of evaluating cloud services for our IFS (Industrial and Financial Systems) implementation, and I wanted to reach out to this knowledgeable community to gather insights and recommendations on the criteria we should consider when making this important decision. Choosing the right cloud service provider is pivotal to the success and efficiency of our IFS deployment. Here are a few questions and criteria I've been pondering: Scalability: How well does the cloud service provider accommodate the scalability needs of IFS as our business grows? What are the options for scaling up or down, and how easy is it to implement these changes?Security and Compliance: What security measures and compliance certifications should we look for to ensure that our sensitive data and operations meet industry standards and regulatory requirements?Performance and Reliability:

HI All,I got the below situation recently for a customer environment in IFS Cloud 23R1. I  had only CUSTOMER_INFO and CUSTOMER_INFO_ADDRESS target tables were marked as ‘In Scope’. When clicked on Expand Scope by Target Table's References One Level, it was taking long time and hung up.Have anyone of you experienced this ?Do you know any particular reason for this and how to overcome this issue?  Thanks in advance!  

 During the installation of version 1.2.0, we encountered an issue with the delivery process known as the 'Delivery Not in Sequence Error'. It appears that the delivery order was not completed correctly. I have attached a screenshot for further information.