Monday, 26 October 2015

Aras Innovator promote item

1.Part has created. (With state as Preliminary)
2.Promote the item using AML.
<AML>
  <Item type="Part" action="promoteItem" where="[PART].item_number='test133' and [PART].is_current='1' and [PART].state='preliminary'">
     <state>Released</state>
  </Item>
</AML>

Tuesday, 13 October 2015

File upload error for Type:Part Number:P001 Name: Rev:A-1 FileName:test.docx ActualFileName:C:\test.docx Error: Database Name Or Database Description Is Wrong.(Check your request and server configuration file)

Error: File upload error for Type:Part Number:P001 Name: Rev:A-1 FileName:test.docx ActualFileName:C:\test.docx Error: Database Name Or Database Description Is Wrong.(Check your request and server configuration file)


Root cause:
Your vault server name is wrong.

Solution:
Go to aras web ui.
AdministrationFile handlingVault
Search -->Default
Check the value.
Vault URL, should your right target server vault url.

How can you get exact url.

Go to Aras innovator SQL Server.
SELECT * FROM [innovator].[VAULT]

Copy [VAULT_URL_PATTERN] value
Update in innovator we ui, go to AdministrationFile handlingVault Search Default

Now try, your problem should be resolve.

Wednesday, 7 October 2015

Thursday, 1 October 2015

Error : 'SOAP-ENV' is an undeclared prefix. Line 1, position 2.

Error : 'SOAP-ENV' is an undeclared prefix. Line 1, position 2.
Solution:
Innovator is not allowing to login, check the Innovator URL, User ID, Password.

Wednesday, 30 September 2015

how to remove empty line when reading text file using C#



IEnumerable<string> lines = File.ReadLines().Where(line => line != "");

or

List<string> lines = File.ReadLines().Where(line => line != "").ToList();

Sunday, 20 September 2015

Not able to connect Integration Services through SSMS


Solution:
To grant access to the Integration Services service

Run Dcomcnfg.exe. Dcomcnfg.exe provides a user interface for modifying certain settings in the registry.
In the Component Services dialog, expand the Component Services > Computers > My Computer > DCOM Config node.
Right-click Microsoft SQL Server Integration Services 11.0, and then click Properties.
On the Security tab, click Edit in the Launch and Activation Permissions area.
Add users and assign appropriate permissions, and then click Ok.
Repeat steps 4 - 5 for Access Permissions.
Restart SQL Server Management Studio.
Restart the Integration Services Service.

Friday, 18 September 2015

Aras Innovator create item using IOM Code

Open Aras server.
Get url of Aras Innovator from C:\Program Files (x86)\Aras\Innovator\VaultServerConfig.xml
<AppServerURL>:
Get Databased name from C:\Program Files (x86)\Aras\Innovator\InnovatorServerConfig.xml
DB-Connection
Now get User ID/Password.
Copy IOM dll from: C:\Program Files (x86)\Aras\Innovator\Innovator\Server\bin

Create a class library.
Add IOM.dll as reference.
Add below code to create a part in Aras Innovator.

   String url = "http://localhost/InnovatorServer/Server/InnovatorServer.aspx";
                        String objBb = "MyDb";
                        String loginName = "admin";
                        String pwd = "innovator";
                        HttpServerConnection conn = IomFactory.CreateHttpServerConnection(url, objBb, loginName, pwd);
                        Item login_result = conn.Login();
                        if (login_result.isError())
                            throw new Exception("Login failed");
                        Innovator myInnovator = login_result.getInnovator();
                        var partItem = myInnovator.newItem("Part", "add");
                        //var partItem = myInnovator.newItem("Part", "merge");

                        partItem.setProperty("item_number", strItemNumber);
                        partItem.setProperty("description", strObjectName);
                        var resultItem = partItem.apply();
                        Console.WriteLine("resultItem " + resultItem);
                        conn.Logout();

                        Console.Read();