如何处理平台问题 [英] How to handle platform issue

问题描述

我有一个程序来获取客户数据作为输出，其中输入值可以是下面提到的这两个中的任何一个。

1.日期范围（从和到日期值）

2.客户名称



最近我们从AIX平台迁移到Linux 。事实上这个程序在AIX平台上运行得很好，但是在迁移之后，似乎对于日期范围没有显示输出。我收到一条评论，检查是否是数据问题。什么是数据问题。同一个程序不能在不同的平台上工作的原因是什么呢？任何帮助都会受到赞赏。



我尝试了什么：



我尝试了它用于在数据库服务器上获取数据的查询，它也提供了输出。但是当它从程序中取出时没有给出输出

Hi,

I have a program to fetch customer data as output where input values can be any of these two mentioned below.
1. date range (from and to date value)
2. customer name

recently we had a migration from AIX platform to Linux. The fact is this program works perfectly in AIX platform, but after migration, seems like for date rang no output is shown. I got a comment to check whether it is data issue or not. What does it mean "data issue". And what can be the reason for the same program to not work on a different platform?Any help would be appreciated.

What I have tried:

I tried the query which it uses to fetch data on db server and it gave output also. But the same when it fetches from program is not giving output

推荐答案

这里有太多未知的东西可供任何人提供很多帮助。我们唯一能提供输入的是关于数据问题的问题，即使这是主观的。



我认为他们在问这是一个数据问题是数据可能因我假设是从服务器A迁移到服务器B而被破坏。他们希望您检查问题表中的任何潜在问题。这需要将服务器A中的表与服务器B中的问题表进行比较并查看是否存在任何问题。



对于您的其余问题，没有很多人都可以做到。我们不是您的同事，不知道您的项目是什么/做什么，我们也无法访问您的计算机，服务器或源代码。



听起来你可能有一个连接字符串问题是我的猜测，这是一个疯狂的猜测，就像我说的那样，任何人都很难提供有价值的输入。



我会解决你的问题，没有结果，并开始排除它不是什么。意思是，你能连接到linux服务器上的数据库，是吗？这不是DB是否启动的问题。然后，编写一个示例脚本或程序来访问所述数据库，它是否可以从代码中运行？大。将连接字符串从服务器A复制到示例应用程序中的服务器B，您的示例/测试应用程序是否仍然有效？没有？然后问题似乎在您的连接字符串中。如果您尝试从本地计算机连接到数据库并且没有任何工作/它超时，那么您的问题很可能是在Linux机器上与防火墙相关，此时您需要调查ip表以及所有有趣的东西来调整任何相关的ACL允许连接。



希望上面给出了一些想法，但也强调了这样一个事实，即我们任何人都无法告诉你你的linux有什么问题server。

There is way too much unknown here for anyone to provide much help. The only thing we can possibly provide input on is your question about data issue, and even that is subjective.

What I assume they are asking about it being a "data issue" is that the data may possibly be corrupted from what I am assuming was a migration from Server A to Server B. They want you to check for any potential issues in your problem tables. That would entail comparing the table from Server A to the problem table in Server B and seeing if there is any issues.

For the rest of your issue, there is not much anyone can do. We aren't your coworkers, don't have any idea what your project is/does nor do we have access to your computer, servers, or source code.

It sounds like you probably have a connection string issue is my guess, and that is a wild guess as like i said, its extremely hard for anyone to provide valuable input.

I would take your issue with getting no results and start to rule out what it isnt. Meaning, can you connect to the database on the linux server, yes? great its not an issue of whether the DB is up or not. Then, write a sample script or program to access said database, does it work from code? great. Copy the connection string from Server A to Server B in your sample app, does your sample/test app still work? No? then issue appears to be in your connection string. If you tried to connect to the DB from your local machine and nothing worked/it timed out, your problem is likely firewall related on the linux box at which point you'll need to investigate ip tables and all that fun stuff to adjust any related ACLs to allow for connectivity.

Hopefully the above gives you some ideas but also highlights the fact that there is no way any of us can tell you whats wrong with your linux server.

您将不得不处理源代码。我最好的猜测是，日期输入的解析器（转换器）在Linux上的工作方式与在AIX上的工作方式不同，因此创建了一些错误消息。他们有时有点奇怪。如果你很幸运，它可能会改变日期设置，如格式，但通常一些熟练的编码员必须应用一些修复。

You will have to deal with the source code. My best guess is that the parser (the translator) of the input to a date works not the same way on Linux as on AIX and so is creating some error messages. They are sometimes a bit strange. When you are very lucky it may be the change of the date settings like format, but normally some skilled coder has to apply some fix.

这篇关于如何处理平台问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！